Execute SSIS package from VB6

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Execute SSIS package from VB6

Execute SSIS package from VB6

Rate Topic

Display Mode

Topic Options

Author

Message

Raul Undreiner

Posted Wednesday, January 30, 2008 1:48 PM

Valued Member

Group: General Forum Members
Last Login: Yesterday @ 2:39 PM
Points: 54, Visits: 272

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

Crispin Proctor

Posted Thursday, January 31, 2008 1:40 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, June 06, 2013 4:31 AM
Points: 917, Visits: 403

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 »

Permissions