Very Computer

In Visual Basic 6.0 when I open up a DTS Task Saved to VB .bas file I get
the following code...

Dim oTask As DTS.Task
Dim oLookup As DTS.Lookup

Dim oCustomTask1 As DTS.DataPumpTask2
Set oTask = goPackage.Tasks.New("DTSDataPumpTask")
Set oCustomTask1 = oTask.CustomTask

I copied it and all the other code into my VB.NET application and this like
causes a "Constructor call is valid only as the first statement in an
instance constructor." message.  How exactly can I convert this into
something that is acceptable to VB.NET?

Thanks for any assistance.

ABH

Hi,
You may modify your DTS Code referring below:
---------
Message: "Constructor call is valid only as the first statement in an
instance constructor"
Occurs on a line such as:
        oTask = goPackage.Tasks.New("DTSExecuteSQLTask")
Comments: Actually a type-casting issue
Solution - Ctype:
        oTask = CType(goPackage, DTS.Package).Tasks.New("DTSExecuteSQLTask")
Also occurs on:
        oTransformation =
oCustomTask3.Transformations.New("DTS.DataPumpTransformCopy")
Solution:
        oTransformation = CType(oCustomTask3,
DTS.DataPumpTask2).Transformations.New("DTS.DataPumpTransformCopy")
--------------------------
HTH,
Regards,
Yan
***This posting is provided 'AS IS' with no warranties, and confers no
rights.*****