Using TI to execute a SSIS package

[JJ2]

Hi Everyone, Is there a way to use TI to execute a SSIS package? Thanks!

[rkaif]

I have not tried this personally. But I believe you can execute a SSIS package through the command line by using the DTEXEC.EXE utility.

Then you can use ExecuteCommand() function in the TI Process to run your command. Syntax is:

Code: Select all

ExecuteCommand(CommandLine, <Wait time>);

Hope it helps!

[JJ2]

Thank you Riswan! I will give this a try.