hi,
Sorry for wrong English if any.
This is with regards to the "Transformation " in SSIS.
We are trying to implement the transformation on excel.While Copying the data from Sheet1 to Sheet2 , sorting and filtering for certain criteria is required.
We tried to do this using the foreach loop.But couldnt code on how to copy the data from the current sheet while looping - to other.
Can anybody help me to for how to get this.
Thanks.
Sorry for wrong English if any.
This is with regards to the "Transformation " in SSIS.
We are trying to implement the transformation on excel.While Copying the data from Sheet1 to Sheet2 , sorting and filtering for certain criteria is required.
We tried to do this using the foreach loop.But couldnt code on how to copy the data from the current sheet while looping - to other.
Can anybody help me to for how to get this.
Thanks.