Can SQL 2008/2005 read SSIS packages created with SQL 2008 R2?

Question

Post reply

Can SQL 2008/2005 read SSIS packages created with SQL 2008 R2?

samalex

SSCertifiable

Points: 5428
More actions
November 2, 2010 at 2:29 pm

#388152

Hi,

I've just moved my primary system to Windows 7 and installed SSMS and BIDS for SQL 2008 R2. All our production systems are running SQL Server 2008 (not R2) or SQL Server 2005, and opening a SQL Server 2005 SSIS package (haven't tried 2008 yet) in BIDS for SQL Server 2008 R2 it launches a Conversion Wizard.

So I take it I'll probably need SQL Server 2005 to modify SSIS packages for servers running SQL 2005, but what about SQL 2008?

I'm trying to avoid having to run so many concurrent versions of everything, but I might not be able to void it I guess.

Also note, I thought I posted this earlier today, but the post didn't come up when I searched for my name or skimmed the Forum I posted under.

Thanks --

Sam

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

tmitchelar Hall of Fame Points: 3391 More actions · Answer 1

There isn't backwards compatibility between 2005 and 2008. You can upgrade a SQL Server 2005 package to a SQL Server 2008 package with a wizard. Typically the only manual edit that I've had to make is in the connection string for the data sources, but other than that it is fairly smooth. You won't be able to read 2008 or higher packages with BIDS 2005.

I'm honestly not sure if SQL Server 2008 can read a SQL Server 2008 R2 package or not. I would imagine so, but am curious myself to confirm.

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 2

samalex (11/2/2010)

Hi,

I've just moved my primary system to Windows 7 and installed SSMS and BIDS for SQL 2008 R2. All our production systems are running SQL Server 2008 (not R2) or SQL Server 2005, and opening a SQL Server 2005 SSIS package (haven't tried 2008 yet) in BIDS for SQL Server 2008 R2 it launches a Conversion Wizard.

So I take it I'll probably need SQL Server 2005 to modify SSIS packages for servers running SQL 2005, but what about SQL 2008?

I'm trying to avoid having to run so many concurrent versions of everything, but I might not be able to void it I guess.

Also note, I thought I posted this earlier today, but the post didn't come up when I searched for my name or skimmed the Forum I posted under.

Thanks --

Sam

You need BIDS 2005 for SQL 2005 packages and BIDS 2008, or 2008 R2, for SQL 2008 packages.

SSIS packages for SQL 2005 and 2008 are not compatible with each other, as you seem to have noticed.

SQL 2005 packages can be easily upgraded to 2008 but will then no longer run on SQL 2005. There is no downgrade option to convert 2008 packages back to 2005.

BIDS for SQL 2008 R2 can be used with SQL 2008 packages. BIDS for SQL 2008 could have some problems with 2008 R2, but that should only happen if you're using one of the few new 2008 R2 components.

BIDS 2005 and 2008/2008R2 can co-exist on the same machine.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

tmitchelar Hall of Fame Points: 3391 More actions · Answer 3

Alvin Ramard (11/2/2010)

SQL 2005 packages can be easily upgraded to 2008 but will then no longer run on SQL 2005. There is no downgrade option to convert 2008 packages back to 2005.

Alvin explained things a lot more eliquiently.

This is a really important point to remember. Definitely keep a backup of your 2005 packages before you upgrade!

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 4

tmitchelar (11/2/2010)

Alvin Ramard (11/2/2010)

SQL 2005 packages can be easily upgraded to 2008 but will then no longer run on SQL 2005. There is no downgrade option to convert 2008 packages back to 2005.

Alvin explained things a lot more eliquiently.

This is a really important point to remember. Definitely keep a backup of your 2005 packages before you upgrade!

What timing? While you were writing this, I was adding a few words to your comment about blocking in another post. 😀

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

tmitchelar Hall of Fame Points: 3391 More actions · Answer 5

tmitchelar

Hall of Fame

Points: 3391

November 2, 2010 at 3:02 pm

#1245767

Alvin Ramard (11/2/2010)

What timing? While you were writing this, I was adding a few words to your comment about blocking in another post. 😀

You complete me :hehe:

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 6

tmitchelar (11/2/2010)

Alvin Ramard (11/2/2010)

What timing? While you were writing this, I was adding a few words to your comment about blocking in another post. 😀

You complete me :hehe:

:w00t:

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]