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.
Does each sheet have the same number of columns and the same column names?
|||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.
|||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.
|||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.
|||I don't quite understand. There is an interface to map your source columns to your destination columns.
|||i found it thank you alot 
No comments:
Post a Comment