SSIS : Script Component

[@mrgogate]

This "script component" transformation will act similar to "Passive" Java Transformation in Informatica. Since its not changing the number of rows...

[@sdang003]

Can you separate the buffer data into multiple tabs inside a single excel file, according to certain column, like say according to the company column. So the excel file with have multiple tabs each for one company, so there will be one for ZENSAR, and that will have all teh employess that work in that company. Any help is appreciated. Thanks.

[@MrSandeep39936]

Once again if we run the package we have column names appended too . How can we solve the problem??

[@usefph6579]

Shows that 'no components are defined in the file'when my pc starts