Is there another way to get input from the user other than the Input
statement. I would like to use something a little more graceful. I don't
want to have to use a front end to my dts package if possible.

Thanks

How about asking the user to save his input to a file, place it at a
pre-defined location, and let your DTS package read/import from that file?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm


"Tim Kelley" <tim.kelley (AT) iddonline (DOT) com> wrote

Is there another way to get input from the user other than the Input
statement. I would like to use something a little more graceful. I don't
want to have to use a front end to my dts package if possible.

Thanks

Then how would you propose getting information from the user to the
application DTS?

If you do not want to use INPUT and you do not want a front end then sure
you could write values to a location and have the DTS package look in those
places but I would still count that as a front end

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Tim Kelley" <tim.kelley (AT) iddonline (DOT) com> wrote

I am looking for more of a 'real-time', prompt the user scenario. If the
program detects a certain condition, I want to ask the operator a question
and execute code depending on the answer.

Thanks for your response


"Narayana Vyas Kondreddi" <answer_me (AT) hotmail (DOT) com> wrote

DTS is not really an interactive application IMHO. The work you describe I
personally would not be doing in DTS. Do you mean DTS is the program in
which you want to detect conditions?



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Tim Kelley" <tim.kelley (AT) iddonline (DOT) com> wrote

Allan,
Yes, DTS is the program I would like to detect the condition in. When
the package runs, it checks
if their are records for the given date, if there are, the dts package
needs to know if the records should be overwritten or not.

Thanks


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Ahhh OK

You build in Workflow then. You make your checks and based on what it finds
you take a particular path. Again I would still not want to prompt the user
for anything. What if this one day becomes a scheduled job? The package
will fall apart if it has to wait for the user. Can you have the reponse to
conditions be entered up front of the DTS package firing and this way it can
read the values at "Condition Encounter time" and take action

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Tim Kelley" <tim.kelley (AT) iddonline (DOT) com> wrote

In message <eWW0hujSEHA.2408 (AT) tk2msftngp13 (DOT) phx.gbl>, Tim Kelley
<tim.kelley (AT) iddonline (DOT) com> writes
You have Input and MsgBox. Remember MsgBox can be used to offer a
choice, Yes, No and even Cancel.

If you want more then you can do this with a custom task. Here is an
example I wrote that provides a run-time UI-

Open File Dialog Custom Task
(http://www.sqldts.com/default.aspx?226)


That is how to do it, but I agree with pervious posts, this is really
*not* a good idea in DTS. Make DTS intelligent to detect and handle
conditions, and capture any input you need up front before staring DTS.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Ilya,

In which way input box is not graceful?

Ilya

"Tim Kelley" <tim.kelley (AT) iddonline (DOT) com> wrote