See if
http://www.sqldts.com/301.aspx can help.
>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
--sb--