January 7, 2008 at 10:37 am
I successfully migrated my DTS packages from sql server 2000 to sql server 2005, but where are they? I'm not able to see dts packages. Please help me, I have been searching the internet and I have found a lot of people asking the same question but I have not seen the answer.
January 7, 2008 at 4:55 pm
Can you describe how you migrated the packages? Did you copy them from a SQL Server 2000 instance to a SQL 2005 instance? Do you expect them to still be DTS packages or were you trying to make SSIS packages?
Greg
Greg
January 8, 2008 at 6:32 am
My goal is for them to be SSIS packages. I used the migration wizard in BI development studio. It said that it was successful but I can't find the packages.
January 8, 2008 at 10:06 am
When you ran the Package Migration Wizard, it should have asked you to select a package destination, either msdb database in a SQL 20005 instance or a .dtsx file in the file system. Do you remember what you selected?
If you chose SQL Server, you should be able to see the packages if you connect to Integration Services in SQL Server Management Studio on the instance you designated for the destination. If you chose to save as files, I think the default is the local computer where you're running BIDS.
Greg
Greg
January 9, 2008 at 2:16 am
I totally agree with greg.
Some more information if you made a project and haven't given a directory to save the project, the project will be saved in the folder of My projects folder(under the my documents folder) of the user who was logged in on the pc where the project was build.
Good luck
Niels Naglé
January 9, 2008 at 3:02 pm
Try expanding Management - then Legacy - then Data Transformation Services.
Or in SQL Server Management Studio in Object Explorer click the Connect drop down and select Integration Services, select the server and Connect. There will be two folders under Integration Services Running Packages and Stored Packages. Expand through Stored Packages and I'm guessing they will be under MSDB there.
Hope that helps!
Stacey
January 16, 2008 at 4:02 pm
Mainframe Dinosaur (1/7/2008)
I successfully migrated my DTS packages from sql server 2000 to sql server 2005, but where are they? I'm not able to see dts packages. Please help me, I have been searching the internet and I have found a lot of people asking the same question but I have not seen the answer.
I did the same thing and during migration elected to store them directly into SQL rather than as a file, and found them in MSDB. To find them, in SQL Server Management Studio, connect to Integration Services where I've imported it to, under the tree Stored Packages --> MSDB, that's where I found them.
Hope this helps. Good luck! 🙂
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply