Sheduling DTS-Packages in SQL2005

[amac]

1. How can you shedule DTS-Packages in SQL2005?
2. When you have created dtsx packages on a server, is it possible for a
user to run that package from this own machine?

[Todd C]

It's been a few years since I dealt with the DTS 2000/ SQL 2005 issues, so
take this advice with cautious optimism:

If you have downloaded and installed the SQL 2005 Legacy Components (should
also be on the install medial) you should be able to manage, edit, and run
older DTS packages from SQL 2005. (In SSMS, look under Management >> Legacy

Post by amac

Data Transformation Services)

To schedule the package, create a stored procdure wrapper that executes the
package, then schedule that SP from SQL Agent. (Sorry, I don't remember the
T-SQL syntax for executing DTS.)

A remote user could invode the stored procedure, start the job, or even run
the DTS Package. The first two should run under the context of the server,
and for the third, the user would need the legacy components installed.

HTH

=====
Todd C

Post by amac
1. How can you shedule DTS-Packages in SQL2005?
2. When you have created dtsx packages on a server, is it possible for a
user to run that package from this own machine?

[Artemakis Artemiou]

1. You can use a SQL Agent job and add a single step for executing the dtsx
package.
For more info: http://support.microsoft.com/kb/912911
This approach will allow you to use scheduling as well.

2. Yes, it possible to remotely execute SSIS packages.
You can checkout the following TechNet blog post on that:
http://blogs.technet.com/reeds/archive/2006/09/22/How-to-remotely-execute-an-SSIS-package.aspx

-

Artemakis Artemiou, SQL Server MVP
http://aartemiou.blogspot.com

Post by amac
1. How can you shedule DTS-Packages in SQL2005?
2. When you have created dtsx packages on a server, is it possible for a
user to run that package from this own machine?