dbTalk Databases Forums  

Save a DTS package as a Visual Basic Module file

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


Discuss Save a DTS package as a Visual Basic Module file in the microsoft.public.sqlserver.dts forum.



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

Default Save a DTS package as a Visual Basic Module file - 08-24-2006 , 11:32 AM






Hi. I have awhole bunch of DTS packages saved a structured storage files. I
need to save them as Visual Basic files in order to examine the code.
However I do not want to open them one by one and do a 'Save as...' as it
will take a long time. I was wondering if I can achieve that using VB in
some way? I have no problem working with packages from VB, but I cannot seem
to find a way to load them then same them as .bas files. I can save them in
SQL server or as a new SSF but not as BAS. The only way to do it so far is
from the interface. I was trying to automate it



Thanks a lot
leo



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.