March 17, 2008 at 10:35 am
In DTS 2000, I usually pass the parameter using /A and run the dts package in the stored procedure. But I can only run SSIS using a job, so how do I pass the global variables to the package?
Thanks
March 21, 2008 at 8:11 am
An Oracle DBA showed me a "trick" over 10 years ago.
He added a table to the database tblPrameters.
The table had two columns:
The first column was the ParameterName.
The second column was the ParameterValue.
Both columns were ASCII string (not unicode).
This table proved to be a handy solution to all sorts of sitations.
HTH
IanO
March 21, 2008 at 10:18 am
The parameter table trick works as you described it, so long as there is no danger that the receivers of the parameters will get confused about which set of parameters are theirs. If you need different user/instances to be able to keep their parameters seperate, then you might want to some more identifying columns (like procedure/job name, instance id, usage time, etc.).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply