Hi,
I have migrated some dts package to sql 2005 by using DTS Migration Wizard ,and i found it under Integration Services\Stored Package\MSDB
but when i click to those package ,it shows no items is there.
Plz suggest me how to open\access these package ,Does it require DTS 2000 Designer Component.
Thanks,
Sheetal
|
| Author: madhavi 25 Oct 2008 | Member Level: Gold | Rating:  Points: 4 |
Integration Services provides the DTS Package Migration Wizard for migrating SQL Server 2000 Data Transformation Services (DTS) packages that were created by using the DTS tools and object model.
for more details open this link. I think it wil helpful for you
http://msdn.microsoft.com/en-us/library/ms143496.aspx
|
| Author: gururajan 11 Nov 2008 | Member Level: Gold | Rating: Points: 6 |
Hi,
You can start the Package Migration Wizard from three locations.
From SQL Server Management Studio. Connect to an instance of the SQL Server Database Engine, right-click the Data Transformation Services node in Object Explorer under Management\Legacy, and select Migration Wizard.
From Business Intelligence Development Studio. Create or open an Integration Services Project, right-click on the SSIS Packages node in Solution Explorer, and select Migrate DTS 2000 Package.
From the command prompt. Start DTSMigrationWizard.exe from the C:\Program Files\Microsoft SQL Server\100\DTS\Binn folder.
After the source and destination have been specified, the Package Migration Wizard lists the packages available in the msdb database, in Meta Data Services, or in the specified structured storage file. You can select the packages to migrate and update the default names that the Package Migration Wizard provides for the packages. You can also update the package names in Business Intelligence Development Studio or SQL Server Management Studio after the packages have been migrated
Gururajan.K
|