I'm trying to convert the VB code auto generated by SQLServer Import/Export
mod into valid VB.net code and am receiving error for the following line:

oTask = goPackage.Tasks.New("DTSDataPumpTask")

This returns a DTS.Task. Is there any other way to create this task?

Hi,
Modify the function parameters:
Use this piece of code
Public Sub Task_Sub1(ByVal goPackage As DTS.Package2)
instead of
Public Sub Task_Sub1(ByVal goPackage As Object)

Also modify the following lines of code too

Public Sub oCustomTask1_Trans_Sub1(ByVal oCustomTask1 As
Object)
this should read as
Public Sub oCustomTask1_Trans_Sub1(ByVal oCustomTask1 As
DTS.DataPumpTask2)

That should solve your problem.

Thanks
Prasad

In article <OKwG0#9dDHA.2140 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Eddie Suey
<esuey (AT) inBizServices (DOT) com> writes
Converting a DTS Package from Visual Basic 6.0 to Visual Basic .Net
(http://www.sqldts.com/default.aspx?264)

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org