in
Questions and answers to issues related to Microsoft: Windows, Applications, Development, Hardware, Server, Internet Protocols, Database, Exchange . » Applications » Visual Interdev » Split flat file into 2 excel files SSIS

Split flat file into 2 excel files SSIS

I need to split a flat file into two excel files. No conditions except maybe if more than 40,000 rows then split. Otherwise just need two files.  
Movie Stars

Solution: Split flat file into 2 excel files SSIS

If you need to split subset to excel file A and rest to Excel file B, then use the conditional split:
http://www.bimonkey.com/2009/06/the-conditional-split-transformation/


If you need to make exact copies to two different Excel sheets, then use the multicast transf