October 14, 2015 at 3:19 pm
How can I get my 2005 SSIS packages to my 2012 SQL server without recreating them. The 2005 SSIS packages are stored in msdb (because they were not created in sql, instead Visual Studio). Will I have to export them to BIDS (as .dtsx) and then import them to my 2012 SQL server, If I do that would they still exists there but I would have just a copy of them. I would like my packages to keep running on my 2k5 server until I'm able to test them on my 2012 server. Any suggestions is appreciated, thank you.
October 16, 2015 at 12:20 pm
You have to take the packages first and pull it on BIDS, this will convert them into project deployment model. When once your new 2012 server is ready you can place the new packages in your SSISDB.
If you want the packages in package deployment model then you can place the packages in msdb database.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply