-
DTS Customization - Help, please!
I create DTS Package with simple transformation task by VB6 code. Then, using SQL DMO I want to create many jobs to run this package, but with parameter, wich customize source sql query.
For example:
ActiveX Script Step of Job1:
Dim o
Set o = CreateObject("DTS.Package"
o.LoadFromServerLoadFromSQLServer "(local)", "sa","",,,,,"My Package"
o.GlobalVariables("Param".Value = 'Value1'
o.Execute
Set o = Nothing
ActiveX Script Step of Job1:
Dim o
Set o = CreateObject("DTS.Package"
o.LoadFromServerLoadFromSQLServer "(local)", "sa","",,,,,"My Package"
o.GlobalVariables("Param".Value = 'Value 2'
o.Execute
Set o = Nothing
Is it correct. And if exists(select best_solution from solutions) help_me
Thank you
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|