Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Xm_cmdshell and dtsrun
Message
From
03/06/2008 10:12:01
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Xm_cmdshell and dtsrun
Environment versions
SQL Server:
SQL Server 7.0
Miscellaneous
Thread ID:
01321294
Message ID:
01321294
Views:
61
Hi,
I am having a issue calling a DTS package designed in SQL 7.

Here is the code:
DECLARE @Command varchar(1000)
DECLARE @file as varchar(1000)

SET @file = '\\MYServer\d$\TraineeFile\CT.xls'

SET @Command = 'DTSRun /S "MYServer" /U "sa" /P "sa" /N "CTS" /A "Filename":"String"="' + @file + '" /W "0" '


print @Command

exec master.dbo.xp_cmdshell @Command
Here is the error I receive.
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...)
Does this have to do with SQL 7 and the /A option??
Thanks you.

A
Next
Reply
Map
View

Click here to load this message in the networking platform