January 20, 2017 at 11:05 am
Hi,
I have a DTS package which was built in SQL 2000 by a team working before me. This was eventually upgraded to SQL 2008 and is currently a DTSX package. Now the customer is upgraded to SQL 2012 but we are unable to get this package to run, hence we have to rebuilt it again. I need some way to open the package to see what is in it so that i can rebuild it in SQL 2012.
Since the developers also have changed from the time original package was built even they are not really sure how it was done except it picks some fields data from database of an instance and puts it into another database in a different instance.
Any help on this very much appreciated.
Thanks,
January 30, 2017 at 5:09 am
harikumar.mindi - Friday, January 20, 2017 11:05 AMHi,I have a DTS package which was built in SQL 2000 by a team working before me. This was eventually upgraded to SQL 2008 and is currently a DTSX package. Now the customer is upgraded to SQL 2012 but we are unable to get this package to run, hence we have to rebuilt it again. I need some way to open the package to see what is in it so that i can rebuild it in SQL 2012.
Since the developers also have changed from the time original package was built even they are not really sure how it was done except it picks some fields data from database of an instance and puts it into another database in a different instance.Any help on this very much appreciated.
Thanks,
If you have the dtsx file of the SQL 2008 version you should be able to open it in the Data Tools Designer for 2012.
If the only location is SSISDB then you can use Data Tools to extract the deployed files and create a new project. In Data Tools create a New Project and select Integration Services from the Project Templates, you then can select Integration Services Import Project Wizard to create the project, select the Server Name where the package id deployed to and then the Project Name from the server and your done.
The only problem you might have is if the original DTS was embedded in a DTSX file, support for this ended with 2008.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply