locked
Looping Through Excel Columns (256 columns) RRS feed

  • Question

  • Hello All,

     

    I have a problem and i wish i can get the answers or advices to solve it.

     

    i have like 20 excel files and in each file there is 1 sheet (Planning) . What i need to do is to loop on the on the 20 files (actually this is the easy part and i already done it) the hard part is while looping i need to open each excel file and loop on the 256 columns in it and extract the data from it to a SQL server Database.

     

     

    Any help will be alot appreciated.

    Wednesday, September 19, 2007 9:17 AM

Answers

  • Perfect, then inside your loop you'll need a data flow task.  Set the source excel connection manager through a variable and send the data to your destination.

    Wednesday, September 19, 2007 2:34 PM

All replies

  • Does each sheet have the same number of columns and the same column names?

    Wednesday, September 19, 2007 1:52 PM
  • Hi, thank you for ur reply, yes the sheets are all the same, same columns name and same column data and same number of columns.

    Wednesday, September 19, 2007 2:30 PM
  • Perfect, then inside your loop you'll need a data flow task.  Set the source excel connection manager through a variable and send the data to your destination.

    Wednesday, September 19, 2007 2:34 PM
  • thats if i wanted to extract the whole excel sheet, wht i want to do is looping on the columns(256), loop on each column and extract it where i want.

    Wednesday, September 19, 2007 2:50 PM
  • I don't quite understand.  There is an interface to map your source columns to your destination columns.

    Wednesday, September 19, 2007 3:05 PM
  • i found it thank you alot Smile

    Wednesday, September 19, 2007 3:08 PM