Error Assigning Task object to Custom Task object while calling DTS APIs in VB.NET 
Author Message
 Error Assigning Task object to Custom Task object while calling DTS APIs in VB.NET

Hello,
I am using DTS in .NET on windows XP and am getting an error at the
statement "oCustomTask1 = oTask.CustomTask". The code snippet is as below :

    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



Fri, 21 Jan 2005 22:35:43 GMT
 Error Assigning Task object to Custom Task object while calling DTS APIs in VB.NET

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.



Sat, 22 Jan 2005 06:31:20 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. DTS Custom task in C# and threading model of DTS C# custom tasks

2. Calling a DTS standard task/custom task from a T-SQL Stored procedure

3. Calling a DTS Custom task from a VB Program - Executable or VB Script

4. Custom DTS Tasks with VB.NET

5. DTS Custom Task and VB.NET

6. VB.NET DTS Custom Task

7. DTS CUstom Task in VB.NET

8. DTS How do you Use a Connection in a Custom Task object

9. Custom task :Query Interface Error in Vb.Net

10. Using a Dynamic Properties Task to set a Custom Task in DTS

11. using a Collection-Object in a VB-Script-DTS-Task

12. Copy SQL Server Objects Task: Error 80045707 and Some Objects Not Copied


 
Powered by phpBB® Forum Software