March 5, 2007 at 9:57 am
Hi there
I am tring to use the /A switch within DTSRUN utility to pass in a global variable,but I cannot get it to work.
I am running it from command line and the DTS package runs through fine but just uses the stored value.
I am passing through a string variable and my syntax is as follows
dtsrun /S <servername> /U <password> /N <packageName /ASource_directory:=8="<variable_value>
doh.. just realised global variables are case sensitive, that's daft
March 8, 2007 at 8:00 am
This was removed by the editor as SPAM
March 9, 2007 at 4:08 am
When using the /A switch I always surround the definition in quotes:
/A "gvFileName=c:\text"
I use a lot of DTS packages in scheduled jobs and use the xp_cmdshell to execute them.
March 12, 2007 at 12:33 pm
That is what I did using xp_cmdshell
EXEC master..xp_cmdshell 'DTSRun /S "ServerName" /E /N "PackageName"
/W "0" /A ReportName:8="ReportName" '
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply