I'm trying to build a DTS Custom Task with VB.net and SQL 2000. Following the 'How To'(http://support.microsoft.com/?kbid=328587)from Microsoft, you are instructed to create a RCW for DTSPkg.dll and then reference it in your project, which I've done. Once I finish the rest of the package, it actually works, but my problem is this:

Once I've built the project, the IDE starts responding VERY slowly as long as I have the reference to the wrapped dll. If I press any key at all, the IDE (Visual Studio 2003) pauses for 10-12 seconds before responding. If I remove the reference to the wrapper, everything works fine again. This is repeatable, and yes, I have all the latest service packs from MS.

Now, if I could develop the custom task without ever testing it, and get it right the first time, this wouldn't be an issue, but as I am a Network Admin by trade, NOT a programmer, there is little chance of that happening.

Has anyone else seen this behavior with dtspkg.dll (or Microsoft.SQLServer.DTSPkg80.dll once wrapped) or any other RCW for that matter?

Thanks in advance...

~Rob Swider