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 @CommandHere 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??