DTS Packages migrated not seen in SQL Server 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

DTS Packages migrated not seen in SQL Server 2005

Author

Topic

murthybng
Starting Member

1 Post

Posted - 2010-02-17 : 11:17:01

I have mingrated a DTS package into SQL Server 2005 database using the migration wizard.

I see the job is completed succesfully but when I look for these jobs under the Management/Legacy/Data Transformation Service, I do not see the migrated packages.

Source: Structured storage File
Destination: Microsoft SQL Server with windows authentication
Source Package: memberDependent
Version: Current version
Destination Package: memberDependent
At this time, i get a message "The package MemberDependent already exists on the server. Do you want to overwrite the package at destination? Click Yes to overwrite the package. Click No to provide a different name". When I give the new name or select overwrite, the pmigration completes successfully but I do not see the packages under the Data Transformation Service.

The first package migrated by is displayed under Management/Legacy/Data Transformation Services. But the above package is not seen.

Can anyone help me in fixing this problem.

Thanks
Sri

Sri

DaleTurley
Yak Posting Veteran

76 Posts

Posted - 2010-02-17 : 11:56:35

Have you tried using;
Server Type: Integration Serices on the login page
and looking under 'Stored Packages' -> 'MSDB'?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-17 : 12:09:26

see

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1251587_mem1,00.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources