I have a command line as following, with DTEXEC to launch the execution of a package and to set a value (13335) of an user variable called CIB (string type):
dtexec /f c:\temp\PackageInsert.dtsx
/set \Package\DataFlowTask.Variables[Utilisateur::CIB].Properties[Value];13335
But I have got an error message saying that the object is not known in the package. My variable does exist in the variable window of the dataflow part.
Thank you for telling me what to set so that the variable can be set by the command line.
Regards,
Marie-Thrèse
I suspect the problem is the path in the set statement, check that the variable is scoped to the data flow task and notthe package for example. To help find the correct path, use the configurations wizard to set the variable value property, and just copy the path you get in there.
|||Thank you so much for your advice. How should I do to use the configurations wizard, in order to get the correct path ?
|||Marie-Thrèse wrote: Thank you so much for your advice. How should I do to use the configurations wizard, in order to get the correct path ?
Every time you set up a configuration you have to tell it which object property you are talking about. On the last screen of the wizard the property paths are displayed.
-Jamie
|||
Thanks a lot Jamie for your advice
No comments:
Post a Comment