thanks that's seems really helpful.

thanks it worked for me by changing run64bit to true.

thank you that was really helpful

thank you anthony for ur time it's really helpful

i did tried to use script task but as i am new to ssis couldn't find the way to solve it, is any one there to elaborate on this please

say for example i have employee table in .csv file and want to transform it by adding new column which should contain unique id for each employee,