Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Calling .net exe file from within SSIS script task.

956 views
Skip to first unread message

doofy

unread,
Feb 7, 2008, 1:49:59 PM2/7/08
to
I've got a ssis package. I need to get it to call an external .exe
file, and pass that file one or two parameters. If I could get it to
receive a return value from the exe, that would be icing on the cake,
but not totally necessary.

The external file was written in vb.net, if that makes any difference at
all, which I doubt it does.

I've looked for the "execute" command, and not finding much. "Call",
not finding much. "Shell", not finding much.

Any help?

Robert Priestley

unread,
Feb 7, 2008, 3:05:11 PM2/7/08
to
A createprocess task should do what you want AFAIK.

http://msdn2.microsoft.com/en-us/library/ms141166.aspx

Rob

"doofy" <no...@would.nt.be.prudent> wrote in message
news:47ab52d0$0$84234$742e...@news.sonic.net...

doofy

unread,
Feb 8, 2008, 12:47:17 PM2/8/08
to
That looks like that way to go. I'm confused with the Arguments
property vs the StandardInputVariable and StandardOutputVariable
properties.

I can see that the output variable would hold some possible output from
the .exe file, but how do Arguments and StandardInputVariable overlap?

What am I supposed to put in the arguments field?

0 new messages