using SQL Server 2005

I have a package variable that I want to map to a parameter that I'm
using in the WHERE clause of a SQL statement.

I'm getting this error on the Data Flow task when executing the
package:
'Value has not been set for parameter 1.'

How can I map that parm to the variable in a Data Flow task? In the
'Execute SQL Task' it's obvious how this is done, but I can't figure it
out in the Data Flow task

darren.harris (AT) thomson (DOT) com wrote:
In dataflow task , In OLEDB Provider , select data access mode as SQL
Command.

write query like
select * from test where id = ?

Select parameter tab on right and map parameter with variable


Regards
Amish Shah

How do you get to 'OLEDB Provider' from the dataflow task?

Thanks



amish wrote: