Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Execute SSIS package from VB6 Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2008 1:48 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 9:30 AM
Points: 67, Visits: 342
I'm starting with SS2k5 and i'm modifying an old program in VB6. I need to execute a SSIS package to load a flat file into a table and run a stored proc per request from within the VB6 program.
The package contains de control flow and data flow to accomplish both steps both I cannot make it run from the VB6 program.

I tried executing the DTEXEC command generated from DDTEXECUI using Shell but get errors and the command is not executed.

Probably doing it the wrong way.

Any help would be appreciated.
Post #449673
Posted Thursday, January 31, 2008 1:40 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, July 14, 2014 3:32 PM
Points: 917, Visits: 412
Not the w rong way. What were the errors????

You can execute a ssis package with CLR. dtxec.exe. Invoke it in VB.





Cheers,
Crispin


I can't die, there are too many people who still have to meet me!

It's not a bug, SQL just misunderstood me!
Post #449838
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse