调用dts包,在存储过程中dtsrun 如何写

把dts储存为结构化存储文件的 DTS 包后写在
存储过程中调用

我写的语句出错,如下

CREATE PROCEDURE my_proc1 AS
dtsrun /F d:\包1.dts
GO

总是说dtsrun 语法错误
又改为dtsrun /F ‘d:\包1.dts’也错,请问如何写??

---------------------------------------------------------------

CREATE PROCEDURE my_proc1 AS
exec master..sp_cmdshell 'dtsrun /F d:\包1.dts'
GO

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus