Custom DTS Tasks with VB.NET

Custom DTS Tasks with VB.NET

Post by MTIsaa » Thu, 28 Feb 2002 05:36:15



All:

I have been attempting to create a simple custom DTS (SQL 2000) task using
VB.NET, but I get the error message "Could not find entry point for
'DllRegisterServer' in the DLL." when regsitering the task from within the
DTS Designer. My research suggests that the DLL is compiled incorrectly, but
I guess I don't understand the issue well enough to correct.

Any suggestions?

MTI

 
 
 

Custom DTS Tasks with VB.NET

Post by Darren Gree » Thu, 07 Mar 2002 04:42:29




Quote:>All:

>I have been attempting to create a simple custom DTS (SQL 2000) task using
>VB.NET, but I get the error message "Could not find entry point for
>'DllRegisterServer' in the DLL." when regsitering the task from within the
>DTS Designer. My research suggests that the DLL is compiled incorrectly, but
>I guess I don't understand the issue well enough to correct.

>Any suggestions?

>MTI

The DLL may have been compiled correctly for .Net,  but it is not a COM
DLL and hence cannot be registered in the old COM way.

Have a look at the C# and DTS presentation-
http://www.sqldev.net/events.htm

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

 
 
 

1. 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

2. New version of Cube Explorer

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

4. Check out the Web below for great Computer Prices >>>>>>>>>>>>

5. DTS Custom Task and VB.NET

6. various questions on column sizes & cleaning up

7. VB.NET DTS Custom Task

8. How do I copy records?

9. DTS CUstom Task in VB.NET

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

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

12. Custom Task created with VB.NET - Please Help!

13. DTS VB custom task reading a global variable and modifying a global variable