Executing Legacy DTS packages - SQL Server Forums

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)

Executing Legacy DTS packages

Author

Topic

SQLBuddy123
Starting Member

26 Posts

Posted - 2009-06-26 : 11:42:13

Hi,

Could anyone tell me how to execute (with an example if possible) the 32-bit legacy DTS packages that were copied from a 32-bit SQL Server 2000 instance to a 64-bit SQL Server 2005 instance?

Thank You,

Yours
SQL Buddy

SQLBuddy123
Starting Member

26 Posts

Posted - 2009-06-26 : 12:29:00

Hi

A small correction in the previous message.

Could anyone tell me the command that should be included in the SQL Server Job step to execute the DTS package (like DTSRun /S "XYZ" /U "sa" /P "password" /N "DTS_Package_Name" ) on the 64-bit Sql Server.

I think we cannot not use the above command on 64-bit SQL Server.

Yours
SQLBuddy

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources