DTS SaveToStorageFile fails in VB.NET when package created with Custom Task -
01-05-2005
, 05:52 AM
I have created a DTS custom task in VB.NET following the method
outlined for C# in
http://support.microsoft.com/default...b;en-us;326909 . I can
use the Custom Task in the DTS designer, create a DTS Package in
VB.NET, execute the package from VB.NET, save the package to SQL Server
from VB.NET, open the saved package in SQL Server DTS designer, and
then save the package from the DTS designer to a structured storage
file - all without any issues at all.
BUT
when I try to use the SaveToStorageFile package method in VB.NET, I get
an "interface not supported" error, and the file being saved to is not
created correctly.
I can successfully use the SaveToStorageFile package method in VB.NET
if the package does not contain the Custom Task. When I step through
the VB.NET code, the .Execute package method works perfectly, but the
running instance of the VB.NET project gets aborted as soon as the
SaveToStorageFile method is called.
This is driving me bonkers .... help pleeeeze!!!!! |