Kent Krug-210111 (11/5/2009)
Can you concatenate variables at the Package Level like in DTS with Global Variables?
I don't remember what it was in DTS, but in SSIS it possible to do it in two ways:
1. You can use expressions. Check this post
for more information.
2. You can use script. The input variables have to be specified in the ReadOnlyVariables
property. The output result variable has to be specified in the ReadWriteVariables
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/