Hello,

In my SSIS package, I generelly load a lot of data for all customers from
database A to database B. However, sometimes, I only want to load data for
specific customers. I've added a string variable used as a parameter called
CustomerFilter, and a SplitByComma SP which, given a comma-separated input
string, returns one row for each element in the CSV-list (although this is
somwhat of a hack, I didn't find a better way to pass arrays as "parameters"
into the SSIS package).

However, due to performance, I don't want to put all customers into that
list when I'm running the package for all customers; I simply want it to
load all data. Any suggestions how I might do this without having to create
two separate packages, and without any "dirty hacks" (like scripting a
manual change of the SQL statements in the data flow tasks)?

To shed some more light on my problem; what I basically want to do is this:

If a list of customers is defined, alter all data flow tasks to include
"WHERE CustomerId IN (ResultFromSplitByComma)".

All suggestions are very welcome!

Thanks.

Regards,
Nils Magnus Englund

Hello,

This website may be of some use to you.

http://www.sommarskog.se/arrays-in-sql.html

It has various Functions/Solutions for splitting arrays in SQL

Hope this helps

Barry