Concatenating string from SSIS for loop task

Question

I have an SSIS package which loops over an array of dates. On each iteration I would like to append the current date to a string to get a full string of all the dates iterated.

What I did was to make an expression where: dateconcatvariable + ", " +currentdatevariable

However, dateconcatvariable is resetting on every iteration of the for loop and so in the end I end up with the last date iterated over instead of all the dates.

the variable is a package level variable.

Any ideas on how to get a concatenation to happen on SSIS?

Thanks!

I'm a bit lost on your design. Could you post a screen shot of the Control Flow and the Data Flow? — billinkc
– billinkc, Commented Aug 29, 2013 at 15:55

Metaphor · Accepted Answer · 2013-08-29 16:05:43Z

1

1. Create a string variable @User::var
2. Use an Expression component and set the expression to @User::var = @User::var + (WSTR, 15)@User::yourdatevar

This should give you the general idea.

answered Aug 29, 2013 at 16:05

Metaphor

6,42512 gold badges58 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Concatenating string from SSIS for loop task

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related