Hi:

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

set pkg = DTSGlobalVariables.Parent
pkg.Tasks("DTSTask_DTSDataPumpTask_1").SourceConne ctionID = 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

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


"Kayda" wrote: