关于dtsrun,100分！

[fuction]

我的代码：
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)

[pengdali]

dtsrun /F"e:\web\wwwroot\sunhing\sqlserver\toolsdepart.dts" /Ntoolsdepart
dtsrun /F"e:\web\wwwroot\sunhing\sqlserver\toolsinfor.dts" /Ntoolsinfor

若要执行保存为 COM 结构化存储文件的 DTS 包，请使用：

dtsrun /Ffilename /Npackage_name /Mpackage_password

若要执行保存在 SQL Server msdb 数据库中的 DTS 包，请使用：

dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name /Mpackage_password

若要执行保存在 Meta Data Services 中的 DTS 包，请使用：

dtsrun /Sserver_name /Uuser_nrame /Ppassword /Npackage_name /Mpackage_password /Rrepository_name

[pengdali]

exec master..xp_cmdshell 'dtsrun /Slyn /E /Ndts_01'

[愉快的登山者]

exec master..xp_cmdshell 'dtsrun /slyn /e /ndts_01'

[fuction]

to 大力：还是不行啊

Error: -2147217900 (80040E14); Provider Error: 14262 (37B6)

Error string: The specified DTS Package ('Name = 'dts_01'; ID.VersionID = {[not specified]}.{[not specified]}') does not exist.

Error source: Microsoft OLE DB Provider for SQL Server

Help file:

Help context: 0




(8 row(s) affected)

[pengdali]

简单方法 做好包后，右键你的包，选调度，设置好后，到作业里把代码考备出来。就OK了，绝对正确

[CrazyFor]

支持~

单方法 做好包后，右键你的包，选调度，设置好后，到作业里把代码考备出来。就OK了，绝对正确

[txlicenhe]

支持用企业管理器中向导操作。

[zjcxc]

支持:
简单方法 做好包后，右键你的包，选调度，设置好后，到作业里把代码考备出来。就OK了，绝对正确