sql server dts: Hi,

I have migrated some DTS jobs from SQL2000 to SQL2005, migration was easy
and straight forward but I can't schedule it to run.

Can someone pls show me how to do that.

Thanks in advance!!

Hello

Once you create (or migrate to) an SSIS package, you must get it from your
BIDS onto the server before you can schedule it.

One way is to 'pull' it down:
*Open SSMS and connect to the SSIS server.
*right click on one of the storrage locations: MSDB or File System
*Select Import. Locate your .dtsx file and load it.

There is aslo a way to 'deploy' you package to the server but I am not that
familiar with that method.

Once stored on the server, simple create an Agent Job. On the Step
properties, the Type should be SSIS Package. From there, you will be given
various properties to set for the package you want.

HTH

--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


[quoted text, click to view]