关于dtsrun,100分!
我的代码:
exec master..xp_cmdshell 'dtsrun /slyn/e/ndts_01'
可是数据包并没有执行,哪位高手告诉我是什么原因,100分送上。
下面是运行后的提示信息:
output
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DTSRun: Must specify a package name or guid or version guid, or a source filename.
DTSRun: Invalid command options
DTSRun Options ('/?' shows this screen; '-' May be substituted for '/'):
Package retrieval and contents:
/~S ServerName /~U UserName /~P Password /E <Use trusted connection instead of /U /P>
/~N PackageName /~M PackagePassword /~G PackageGuidString /~V PackageVersionGuidString
/~F Structured Storage UNC filename (overwritten if /S also specified)
/~R Repository Database Name <uses default if blank; loads package from Repository>
DTSRun action (default is to execute Package):
/!X <Do not execute; retrieves Package to /F filename>
/!D <Do not execute; drop package from SQL Server (cannot drop from Storage File)>
/!Y <Do not execute; output encrypted command line>
/!C <Copies command line to Windows clipboard (may be used with /!Y and /!X)>
Notes:
~ is optional; if present, the parameter is hex text of encrypted value (0x313233...)
Whitespace between command switch and value is optional
Embedded whitespace in values must be embedded in double-quotes
If an option is specified multiple times, the last one wins
(19 row(s) affected)