Need to move DTS package from PC to Server

[schusser]

I have a DTS package that I run from my PC that imports data from ServerA (SQLBase) to ServerB (SQL Server). It involves over 20 tables.

I am trying to automate this procedure so that it can be scheduled to execute during off hours. What do I need to have in place on ServerB? Can the package be copied or saved to the server (this doesn't appear to bo an option)? Or do I need to recreate the package (UGH)?

Thanks in advance for your help.

 

[JayKusch]

Look in BOL (Books OnLine) under "DTS packages, saving"

Your have three methods to choose from.

This may help in choosing the "Best Practices" method ...

http://weblogs.asp.net/bi_systems/articles/162785.aspx

Thanks

J. Kusch

 

[EdwinGene]

To schedule a DTS package, right-click on the package name in the list of Local DTS Packages, and select "Schedule Package..." This will create a SQL Server Agent job with the same name as the DTS package, which you can view and modify by going to "Management=>SQL Server Agent=>Jobs" in the server explorer on the left side of Enterprise Manager.