I'm new to SSIS and I need to build a dataflow that imports multiple flat files (all with the sanme field layout) into one SQL table. I've built the dataflow for one but now I need to add all the other flat files. Although I have a little experience in C#, my preference would be to do this without writing C# code.. Therefore, I believe I will need a separate connection manager for each file, correct? When I add a 2nd source connection manager and try to add a 2nd flow to the OLEDB table destinatiion, I get a message that there are no available imputs. Will I need to have a a separate copy of the destination for each source, or is there a better way to accomplish?