Hi Ed, Thanks for the response.

As I mentioned, the specification can be defined using 3, 4, or more values. In the example I provided, they can go in separate...

It turned out that SSIS was at SP1 while SQL Server was at SP2. So after upgrading SSIS to SP2 and installing Data tools for Visual Studio 2012 the problem...

Thank you for the suggestion about the Case statement Erland. Regarding my actual problem, it turns out that both approaches (my original and your suggested) return identical results.

I investigated...