Execute SSIS package from VB6

• Raul Undreiner

  SSCommitted

  Points: 1554

  More actions

  January 30, 2008 at 1:48 pm

  #127653

  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.

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  January 31, 2008 at 1:40 am

  #773655

  Not the w rong way. What were the errors????

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

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!