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