SSIS - how to use a for each loop container to import mulitpule xls files

• adam spencer

  Hall of Fame

  Points: 3926

  More actions

  September 29, 2009 at 6:46 am

  #214870

  Please do not let below sound like I am tring to get figure too much out, the link just shows the steps i followed to put a connection string variable into the for each loop container edit window.

  I simply need to know how, when I go into data flow tab and drag an excel source, how to set it. obviously it gives me an error.

  if i am using a connection manager that in its expressions property it is set to use the connectionstring variable for its connection.

  SO If i pointed the edit window of my loop container to the folder with the xls files, then created and told the loop to use a variable strConnectionString > then went to my connection manager and pointed to 1 file in that folder and then in expressions property of the connection manager told it that connection string is my variable, how do i then go to data flow and edit my excel source connection to be dynamic. I just get errors. the person with this post brought me so close and not all the way. cause at my job, our IS department really needs this to work. ANyone done this before?

  OK - SO i googled this link, that it was just what i need except It said the details of the data task we will not go into details .But thats exactly what I need to finish the project. here is the link if you want to see where it left me off.

  http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx

  any help I would greatly appreciate

• MWise

  SSCarpal Tunnel

  Points: 4074

  More actions

  September 29, 2009 at 1:55 pm

  #1059705

  Try http://msdn.microsoft.com/en-us/library/ms345182.aspx