Transfer the data from xls sheet to sqlserver using SSIS
-
Hi, I need to transfer the data from xls sheet to sqlserver but actually the thing is if the source excel file has different sheets, in each sheet i have the data and i need to move the entire data( all the data that is present in all sheets of the excel file) to a single table into sql server like wise I have many xls files ( which have many sheets ) . for eg: excel file 1: -> sheet 1 -> sheet 2 -> sheet 3 excel file 2: -> sheet 1 -> sheet 2 -> sheet 3 excel file 3: -> sheet 1 -> sheet 2 -> sheet 3 now i need to get the data from all of the files and i need to insert into a single table ( sql server) in ssis package so plz help me by giving the solution . thanks
-
Hi, I need to transfer the data from xls sheet to sqlserver but actually the thing is if the source excel file has different sheets, in each sheet i have the data and i need to move the entire data( all the data that is present in all sheets of the excel file) to a single table into sql server like wise I have many xls files ( which have many sheets ) . for eg: excel file 1: -> sheet 1 -> sheet 2 -> sheet 3 excel file 2: -> sheet 1 -> sheet 2 -> sheet 3 excel file 3: -> sheet 1 -> sheet 2 -> sheet 3 now i need to get the data from all of the files and i need to insert into a single table ( sql server) in ssis package so plz help me by giving the solution . thanks
AFAIK you would have to do this sheet by sheet. For more info: Excel Source[^]
The need to optimize rises from a bad design.My articles[^]
-
Hi, I need to transfer the data from xls sheet to sqlserver but actually the thing is if the source excel file has different sheets, in each sheet i have the data and i need to move the entire data( all the data that is present in all sheets of the excel file) to a single table into sql server like wise I have many xls files ( which have many sheets ) . for eg: excel file 1: -> sheet 1 -> sheet 2 -> sheet 3 excel file 2: -> sheet 1 -> sheet 2 -> sheet 3 excel file 3: -> sheet 1 -> sheet 2 -> sheet 3 now i need to get the data from all of the files and i need to insert into a single table ( sql server) in ssis package so plz help me by giving the solution . thanks