Hi,

Is is possible to pass parameters to dts package, that we need to run using
dtsrun. I have a query like - select a,b,c from table where id in ('x','y').
We need to parameterise the 'in' CLAUSE. What is there in the 'in' CLAUSE can
be more than I have given and it frequently changes. Could someone give a
solution for this.

Thanks in Advance
Suhas

A quick and simple way is to build your SQLStatement like this

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

You can then pass in the values of the variables to the package using DTSRUN
and the /A switch.


OR


depending how you call the package you could set the SQL Statement using the
object model through code.


OR


You could use the first suggestion but have the package look up the values
in a SQL Server table using the Dynamic Properties task.





"Suhas Vengilat" <SuhasVengilat (AT) discussions (DOT) microsoft.com> wrote

Hi Allan,

Thanks a lot for these info. I am going to try this and get back to you.

Thanks again.
Suhas


"Allan Mitchell" wrote: