Dear Custom DTS Task Writers:

If you have written a Custom DTS Task in .Net, please attempt to modify your
custom task within an ActiveX script. To do so, add your Custom DTS Task to
a new package, add an ActiveX Script Task, and set its code to similar to
below:

Dim oPackage
Dim oCustomTask

set oPackage = DTSGlobalVariables.Parent
set oCustomTask = oPackage.Tasks("[Get the Tasks name from disconnected
view and paste here]").CustomTask

oCustomTask.[CustomProperty] = "Hello World!" *OR*
oCustomTask.[CustomMethod]

Main = DTSTaskExecResult_Success

The Property or Method must be one you have added other than the ones you
are required to include.......other than Name and Description.

If the script correctly runs, please may I have a copy of your code so I can
figure out what I've done wrong in mine. Mine works for everything, except
for accessing this way.

Scott

Workaround is to use the properties collection, e.g.

oCustomTask.Properties("MyProperty").Value = "Fred"


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

"Wm. Scott Miller" <Scott.Miller (AT) spam (DOT) killer.wvinsurance.gov> wrote in
message news:uajBoGtuEHA.1260 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

Darren:

Thanks for the reply!

I cut and pasted your code into my routine and all I get is errors.
Specifically, "Wrong number of arguments or invalid property assignment:
'oCustomTask.Properties'" Any ideas?

Scott

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote

Darren:

I worked on it and found that I had made a modification that broke the
disconnected view of my custom task. After fixing that, I found that the
actual syntax is as below:

oCustomTask.Properties.Item("MyProperty").Value

Additionally, if you follow Microsoft's suggestion to "return null" for the
Properties collection you get a "Object Required" error. You must implement
Properties as follows:

Properties oProps;
PropertiesProviderClass oPropProvider = new PropertiesProviderClass();
oProps = oPropProvider.GetPropertiesForObject(this);
oPropProvider = null;
return oProps;

Just thought I would let you and others reading this know.

So it appears that you cannot create your own methods on a custom task and
use them with .NET. Sounds like they went backwards on that one as every
other language I've used to write custom tasks works fine in the ActiveX
Script mode. I changed my method to a property that just runs and returns
that same information and I could access it the way you said. Looks like
the Microsoft documentation is incorrect (they also say the syntax you gave
will work and it doesn't--they provide both syntaxes right next to each
other in their HOW TO document and only one works) or at least they don't
make it known that accessing anything but Name and Description according to
their example doesn't work. Do you happen to know the reason for this not
working?

Thanks for your help,
Scott

"Wm. Scott Miller" <Scott.Miller (AT) spam (DOT) killer.wvinsurance.gov> wrote in
message news:OoWAzD2uEHA.4028 (AT) TK2MSFTNGP15 (DOT) phx.gbl...