August 16, 2002 at 1:54 pm
OK i'm trying something new out with DTS. I saved my DTS package that i created as VB.
When you do this it creates it as a code module. I proceded to create a button that when pressed calls the module to run the DTS package. My problem is how to actually call the module. Any suggestions. I'm willing to give more information if needed.
thank you
rich
RICHARD KIRMSS
RICHARD KIRMSS
August 18, 2002 at 10:50 am
Look up the article "Running a DTS Package Saved as a Visual Basic File" in BOL
Diane
August 20, 2002 at 12:46 pm
I tried the VB program with out the button and it works fine. I guess what my problem is, is that if I have a button what am i suppost to call in the module to have it run. Obviously I can't call main because that is private. There are 5 sub funtions besides main that are public. I tried calling them and i still get error message. Does any one know the syntax to call a procedure from a module.
i thought it was:
call module_name.procedure_name ()
any help would be greatly apprieciated.
thank you rich
RICHARD KIRMSS
RICHARD KIRMSS
August 20, 2002 at 1:03 pm
I figured out what i had to do
Since the main procedure in the Module is private and it calls all the other public procedures I had to create another public procedure to call the main procedure. Which then can run the DTS package
RICHARD KIRMSS
RICHARD KIRMSS
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply