dbTalk Databases Forums  

DTS SaveToStorageFile fails in VB.NET when package created with Custom Task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS SaveToStorageFile fails in VB.NET when package created with Custom Task in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
rusted
 
Posts: n/a

Default 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!!!!!


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.