Hello, I want write an insert statement in a SQL task that I would like to be
able to pass an input paramter. For example:

insert into TableA (col1, col2)
select EmployeeID,?
from employees
where .........

Another variation

insert into TableA (col1, col2)
select EmployeeID, employeename
from employees
where employeeID = ?

The ? is an input parameter defined earlier in the package. This does not
work. Is there another way to do this?

Ric

Hello Ric,

The first example should not work at all (you cannot put a param there),
but the second should be good; did you map your param correctly with a Global
Variable with a proper value?

Bye

Hello,

I am not that familiar with DTS but in SSIS you can build an expression
for the sql statement you want to execute, there you can use
parameters.

Lilja

Ric wrote: