May 17, 2005 at 4:40 am
Hello
I need to run a VB module that process a memo field from a ddbb table to obtain three date type fields that will be stored n another table.
This module have to be runned from a DTS package after some action.
How can I make it work?
How can I execute this module from a DTS?
Thank you
May 17, 2005 at 4:54 am
If you have not had any real exposure to using vb with packages then the first port of call should be the site http://www.sqldts.com
If you search the site, you will see numerous well explained examples.
May 17, 2005 at 8:01 am
Yes, I have taken a look to this web, but the only I could find is about executing a DTS package from a VB code. What I need to know is how to execute an VB module from a DTS whitout using the activeX module wich is included in DTS Wizard...
May 17, 2005 at 8:35 am
Where does the vb module reside and what application is it attached to?
If it is word or excel, you just need to open the application from a batch file called from your package via an 'Execute Process Task'. Eg the batch file will have something like "excel.exe "c:\test.xls"" - This opens test.xls in excel
Then make sure the run macro statement is attached to the document_Open event or equivalent in the application. E.g for excel code under " public sub Workbook_Open"
May 18, 2005 at 4:21 am
save the vb module as .dll or active control and execute a extended stored procedure in sql task of dts.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply