SSIS Package Prompt Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CSwartz - 08 Feb 2010 18:16 GMT

Is it possible for a SSIS pacakge to prompt for a parameter/variable before
running?

Thanks.

Reply to this Message

Bob Barrows - 08 Feb 2010 18:34 GMT

> Is it possible for a SSIS pacakge to prompt for a parameter/variable
> before running?

No, packages are intended to run without user intervention. But it is
possible for a program to prompt for a value and pass it to the package
when it executes the package via dtsexec.exe .....

Signature

HTH,
Bob Barrows

Reply to this Message

Gennadi Gretchkosiy - 08 Feb 2010 23:18 GMT

It is possible but rather then "before" - "during" package run. You can use
Script task for this. But this looks not very usefull from point of view of
purpose SSIS packages are used.

Regards,
Gennadi

> Is it possible for a SSIS pacakge to prompt for a parameter/variable before
> running?
>
> Thanks.

Reply to this Message

Bob Barrows - 09 Feb 2010 14:25 GMT

Really? I'll have to try that. I was assuming that Inputbox and MsgBox
functionality was not available in a package.

I now see I was wrong. Both commands are available and work.

> It is possible but rather then "before" - "during" package run. You
> can use Script task for this. But this looks not very usefull from
[quoted text clipped - 7 lines]
>>
>> Thanks.

Signature

HTH,
Bob Barrows

Reply to this Message