Hi there,
Through the Disconnected Edit screen it looks like each
datapump task has a transformations collection but I can't
get a reference to it in code.

I've got as far as

set objMyTask = DTSGlobalVariables.Parent.Tasks("MyTask")

But as soon as I go
objMyTask.transformations("Trans1")
etc... it throws an error.

Can anyone help. I'm sure this can't be too difficult.

TIA

Regards
Jamie Thomson

The guts of a task is on the custom task. The Task class acts as a wrapper
for the type specific class, e.g. DataPumpTask Object.


Set oDataPump = oPkg.Tasks("MyDataPumpTask").CustomTask

--
Darren Green
http://www.sqldts.com

"Jamie Thomson" <jamie.thomson (AT) int21 (DOT) com> wrote