I have tried the above suggestion on making the task work but I still can not get it to work.

I have defined a task as stated above but when I do the following:

oTask = pkg.Tasks.New.....

The compiler states that pkg does not have these members.

Please can any one advise on what I need to do.

Kind regards

Wayne

---
Posted using Wimdows.net NntpNews Component -

Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

Not sure what you want to do really as there is no thread for this in the
newsgroup, but quick gues might be the use of Set, and New expects a
parameter of the type of task e.g.

Set oTask = goPackage.Tasks.New("DTSActiveScriptTask")



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

"SqlJunkies User" <User@-NOSPAM-SqlJunkies.com> wrote