[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1837
  • Last Modified:

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

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!
0
vhpcomp
Asked:
vhpcomp
  • 3
  • 2
1 Solution
 
brejkCommented:
Use this nice little article: http://www.sqlis.com/55.aspx. ForEach Loop container, variables and Expressions property is what you need to use.
0
 
vhpcompAuthor Commented:
Perfect, this is much better than building 50+ connections! Thanks.
0
 
brejkCommented:
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) ;-)
0
 
vhpcompAuthor Commented:
whoops, new interface since I was last here. It gets worse -Now I  accepted my comment as the solution!  I will get this corrected.
0
 
brejkCommented:
I've been visiting this site since January so for me this GUI is the only one I know :-) Thanks.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now