Setting SourceConnectionID Property -- sql server dts

Kayda
5/12/2006 6:03:10 AM

Hi:

I am trying to set the SourceConnectionID in an ActiveX Script Task at
runtime:

set pkg = DTSGlobalVariables.Parent
pkg.Tasks("DTSTask_DTSDataPumpTask_1").SourceConnectionID = 34

...and when I run the package I get an error saying:

"object doesn't support this property or method"

Shouldn't I be able to set this property?

Thanks,
Kayda

Darren Green
5/12/2006 8:47:01 AM

The task has the basic properties only, the meat of it is the custom task,

Try something like this -

pkg.Tasks("DTSTask_DTSDataPumpTask_1").CustomTask.SourceConnectionID = 34

--
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Setting SourceConnectionID Property