开发者

Scheduling DTS in SQL Server 2008

开发者 https://www.devze.com 2023-03-25 19:35 出处:网络
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 pa

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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号