Very Computer

    Dim oTask as DTS.Task
    Dim oCustomTask1 as DTS.BulkInsertTask

    oTask = goPackage.Tasks.New("DTSBulkInsertTask")
    oTask.Name = "DTSTask_DTSBulkInsertTask_1"

    oCustomTask1 = oTask.CustomTask           ---- THIS THROWS AN ERROR
"QueryInterface for interface DTS.CustomTask failed"

Could someone tell me how to solve the problem?

Thanks,
Rajesh

Rajesh,

Have you installed SQL Server Service Pack 2?
http://www.microsoft.com/sql/downloads/2000/sp2.asp

In my experience, Service Pack 2 has always resolved this error message on
the CustomTask interface. Please let me know your results.

-Doug

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.