I created a DTS package that imports text data into a SQL
table. After the import I have a parameter query to
update the imported data with a batch number. The query
is set to ask for the batch number using "?" to create
a "run time" parameter. The query runs fine in the "Data
Transformation Services Query Designer", asking for the
parameter and all. However, when running the DTS as a
whole it doesn't ask for the parameter and I get a "No
value given for one or more required parameters." error.
How do I get the DTS package to ask for the parameter?
Thanks for any help. Kathy

Hi Kathy,
Include "Set nocount on" at the begining of you t-sql sentence.

JFB

"Kathy Atchley" <kathy_atchley (AT) aon (DOT) com> wrote