Hi All,

I am trying to run a dtsx from the command line and pass a value to a user
variable. Anyone know how to do this?


Cheers

Mark

Hello Mark,

Have you taken a look at DTExecUI. This will build the command line for you.

But it will look something like

/SET \package\DataFlowTask.Variables[User::MyVariable].Properties[Value];newValue


From BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlcmpt9/html/89edab2d-fb38-4e86-a61e-38621a214154.htm


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com