Page 1 of 1
Using TI to execute a SSIS package
Posted: Mon Aug 30, 2010 8:11 pm
by JJ2
Hi Everyone, Is there a way to use TI to execute a SSIS package? Thanks!
Re: Using TI to execute a SSIS package
Posted: Mon Aug 30, 2010 8:55 pm
by 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!
Re: Using TI to execute a SSIS package
Posted: Tue Aug 31, 2010 8:30 pm
by JJ2
Thank you Riswan! I will give this a try.