What is this in DTS? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

What is this in DTS?

Author

Topic

jesus4u
Posting Yak Master

204 Posts

Posted - 2003-02-27 : 09:47:56

Using ActiveX scripting what in the world is this?


	set pkg = DTSGlobalVariables.Parent
	set stpEnterLoop = pkg.Steps("DTSStep_DTSDataPumpTask_1")
	set stpFinished = pkg.Steps("DTSStep_DTSActiveScriptTask_5")

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-02-27 : 10:01:13

set pkg = DTSGlobalVariables.Parent

This assigns pkg an object which references the DTSGlobalVariables Parent the DTS Package.

set stpEnterLoop = pkg.Steps("DTSStep_DTSDataPumpTask_1")
This assigns stpEnterLoop an object which references the first Data Pump Task in the Package.

set stpFinished = pkg.Steps("DTSStep_DTSActiveScriptTask_5")
This assigns stpFinished an object which references the 5 ActiveX Script Task in the Package.

jesus4u
Posting Yak Master

204 Posts

Posted - 2003-02-27 : 10:07:37

thank you. That is what I figured but I wanted to ask.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources