Hello,
I am New to DTS as I know how to run the dts (.bas) from the
vb but I am converting it into
vb .net 2005 but it is giving the error.pls help me.
I am submitting the code as below
Dim oTask As DTS.Task
Dim oLookup As DTS.Lookup
Dim oCustomTask1 As DTS.CustomTask
CType(goPackage, DTS.Package).Tasks.New("DTSDataPumpTask")
oTask = CType(goPackage, DTS.Package).Tasks.New("DTSDataPumpTask")
oCustomTask1= oTask.customtask(Here the error occured)
as
Unable to cast COM object of type 'System.__ComObject' to interface type 'DTS.CustomTask'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{10020904-EB1C-11CF-AE6E-00AA004A34D5}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).