When developing a custom task or just manipulating the DTS objects through
.Net you may recive the following error:
QueryInterface for interface DTS.CustomTask failed
This error has been fixed in SQL Server 200 Service Pack 2. Make sure you
apply the service pack to the SQL Server machine, and any client machines
that will be running the .Net code, since DTS is a client side tool.