November 13, 2006 at 6:45 pm
I have migrated a SQL 2000 DTS Package to SQL 2005 SSIS however, How do I now view the SSIS Package with BIDS? I have no idea where the Migration Wizard has stored the newly migrated DTS Package!
In addition, is it possible to view the SSIS Packages names in SQL Server Management Studio?
November 14, 2006 at 7:59 am
I believe the migration wizard asks you where you wish to store the migrated package files on the second step... You could try rerunning and noting the destination.. as for opening in SSMS, yes, if you do a file/ open and pick the dtsx file, it will open the package.
November 14, 2006 at 3:12 pm
November 15, 2006 at 8:41 am
You could also migrate directly into a BIDS solution.
Right click on Packages node in solution explorer and select Migrate DTS 2000 package.
Rick
November 15, 2006 at 9:41 am
there is also a DTS viewer as part of the feature pack you should download. it lets you view and modify the package in a DTS 2000 environment. I needed it for one of my packages
November 16, 2006 at 8:37 am
That´s correct. I wouldn´t migrate the package but execute it within ssis with the "execute DTS"-Task.
Here you can find the DTS designer for BIDS:
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply