Scheduling DTS in SQL Server 2008
We are moving from SQL Server 2000 to 2008 and currently just migrating our DTS packages without converting them to SSIS. I can't find a way to create schedule开发者_如何转开发d jobs for those DTS packages. Can somebody help, please?
You'd want to use the dtsrun utility in a job step of a SQL Agent job.
See: Running SQL Server 2000 DTS Packages from SQL Server Agent Jobs
精彩评论