I was wondering if someone could provide me with a bit info on how to Set Values in the dtexecui?
I have a package that does a T-SQL SELECT query with a @.var, and that @.var needs to be set at runtime, in the Agent Job....
Thanks in advance.
Nevermind, having a slllllowwww moment this morning, need more coffee:)In case others would like to know:
\Package.Variables[User::VAR_NAME].Properties[Value] : VAR_VALUE|||I've submitted a DCR to get a GUI interface as part of dtexecui that allows you to generate these property pathswithout typing them in yourself. It shouldn't be hard seeing as the same thing already exists in SSIS Designer.
In the meantime, the way to generate these property paths is using the XML configuration file wizard within SSIS Designer.
I'm sure you know this Jason :)
-Jamie|||Is it Feedback. Got a reference I can vote on? Drives me round the twist too.|||
DarrenSQLIS wrote:
Is it Feedback. Got a reference I can vote on? Drives me round the twist too.
Nah. I did it thru betaplace!
No comments:
Post a Comment