Hi,

I use a SSIS package to load data with specific ID's from one database to
another. Currently, I use a variable called "IdFilter" which I set to the Id
I want to load data for. I then use a Conditional Split with the condition
"Id == @[User::IdFilter]" to fetch only the rows I want before storing them
in the destination table.

Due to the fact that this package is run for a lot of Id's, and that the
package takes a while to run, I would like to make it possible to specify
several Id's in the IdFilter, so the source SQL query is a bit like "SELECT
* FROM Source WHERE Id IN (1,2,3,...)", where 1,2,3 are the Id's specified
in the IdFilter. Any suggestions as to how this can be accomplished?
Preferably, I want to avoid hacks like comma-separating the Id's in a string
parameter, but all suggestions are welcome...


Regards,
Nils Magnus Englund