I have a DTS package, which receives data from a SQL server 2000, and delivers this to a text file.

My Package basically contains a SELECT statement with a WHERE clause.

Obviously, I could create some global Variables in my WHERE clause, and support these from my VB program. My problem is, I don't know how many parameters I have to use in the WHERE clause from time to time.

Since the SELECT statement never changes, (if I does, I want to administrate it from the DTS Designer), I want to keep the SELECT statement in the package, and every time I run the package (from VB), I want to support it with a WHERE clause.

Is this possible?

Thank you.