DTS 2

[Morningstarr]

Is there a way to have two different datapump objects and have an active x script choose which one will execute at runtime?
Thanks,
Dawn

 

[jhall156]

I think you can. Create a DTS.Package object and a DTS.Step object,
invoke LoadFromSQLServer of the package object,
set your step object to YourPackage.Steps("DTSStep_DataPumpTask_whichevernumber&quot
Then invoke the execute method of the step object.


JHall

 

[tlbroadbent]

Check the articles on Workflow at SQLDTS.com.

http://www.sqldts.com/catlist.asp?nav=1,6,103,5

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

 

[Morningstarr]

Excellent!! Thank you both

 

[jhall156]

Terry,
Would you take a look at thread183-236716. I would like to know the answer myself. Thanks very much. JHall