>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 >>
>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...) > >>