SSIS PAckage devloped in 2005
Hi Can a SSIS package developed in 2005 be opened in 2008.willl there be any conversions involved while opening the package in the designer. Thanks
November 15th, 2010 11:52pm

Yes, it can be opened. While doing so the package will be upgraded to 2008 version and cannot be opened using BIDS of SQL Server 2005 (VS 2005)Nitesh Rai- Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 11:56pm

It can be opened in SQL 2008 , As Nithesh said it will be upgraded to 2008 and one more thing you may face an issue with oledb provider while running the upgraded package, it can be resolved by installing "sqlncli" refer http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/920a0817-d9b8-4766-b0bf-baa6430acf93 for more details.-Manivannan
November 16th, 2010 12:09am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics