<div>
Perfect, this is much better than building 50+ connections! Thanks.
</div>


Perfect, this is much better than building 50+ connections! Thanks.

<div>
I am happy that you like it. Don't forget to check the answer as a solution for the problem (and to award me with some points maybe) ;-)
</div>


I am happy that you like it. Don't forget to check the answer as a solution for the problem (and to award me with some points maybe) ;-)

<div>
whoops, new interface since I was last here. It gets worse -Now I &nbsp;accepted my comment as the solution! &nbsp;I will get this corrected.
</div>


whoops, new interface since I was last here. It gets worse -Now I  accepted my comment as the solution!  I will get this corrected.

<div>
I've been visiting this site since January so for me this GUI is the only one I know :-) Thanks. 
</div>


I've been visiting this site since January so for me this GUI is the only one I know :-) Thanks.

<div>
<div class="content wysiwyg-content">
I'm &nbsp;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. &nbsp;I've built the dataflow for one but now I need to add all the other flat files. &nbsp;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? &nbsp;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. &nbsp;Will I need to have a a separate copy of the destination for each source, or is there a better way to accomplish?<br />
Thanks!<br />

</div>
</div>


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?
Thanks!


SSIS - import multiple flat files with same fields into one SQL Table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.