Using the /A switch to pass global variables to a dts package

• tim blair-356474

  Valued Member

  Points: 67

  More actions

  March 5, 2007 at 9:57 am

  #68891

  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

• Adrian Nichols-360275

  SSCertifiable

  Points: 7694

  More actions

  March 9, 2007 at 4:08 am

  #694033

  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.

  ---

  
  Ade

  A Freudian Slip is when you say one thing and mean your mother.
  For detail-enriched answers, ask detail-enriched questions...[/url]

• Loner

  SSC-Insane

  Points: 21279

  More actions

  March 12, 2007 at 12:33 pm

  #694466

  That is what I did using xp_cmdshell

  EXEC master..xp_cmdshell 'DTSRun /S "ServerName" /E /N "PackageName"

  /W "0"  /A ReportName:8="ReportName" '