Yes , what you said is correct ..thanks 🙂

If i understood you correctly, you would like to use SSIS to implement conditions and populate Column C

Use Derived Column in SSIS

and following is the expression to be used...

It is just an example in my case..date will be appeneded along with the text i mentioned in double quotes

Yes , you have to use expressions and this can also be done using script

following is an example for Expression, which attaches date to the name

"MP_CCRET"+

Right((DT_WSTR, 4)year(getdate()) ,2)

+ (...

could you be more specific? do you want to add time stamp to the name ?

Hi,

I had same issue but i was using table data region...what i did to overcome this issue, changed my sql using differnt joins to combine all the datasets data into...