Cannot programmatically load and save DTS package that has custom task -
01-11-2005
, 01:55 PM
Hi,
I have a DTS package which has a COM custom task written in VB. When I
try to load from a storage DTS file and save this DTS package to SQL
Server by using DTS.Package2 object model, all the arrows between tasks
and this COM custom task are gone in the saved version in SQL Server.
But if I don't use the COM custom task, it seems that DTS object model
can load and save it to SQL Server.
Any idea why the DTS package object model has this limitation? Any work
around for this?
Many thanks!
Mike |