Hi, Using SSIS how to split 4 columns in excel file into two columns in one file and two columns into the other excel files. Thanks sandeep

you have to use multicast transformation inside the Data flow task (DFT) and us e2 excel destination. map the column as required for each excel file. Let us TRY this | Mail me My Blog :: http://quest4gen.blogspot.com/

You can use the multicast transformation to copy the data flow and add two excel destinations.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com