Unanswered: How can I dynamicly change the Where clause in a DTS package from Visual Basic
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.