Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
learntsql
524 Posts |
 Posted - 2012-05-04 : 06:47:01
|
| Hi all,I have an excel sheet with the following columns.This excel sheet we get daily by adding new dates to the same sheet again.Sno-Group-TableDesc-Date1-Date2-Date3-------1-A-Table1-10-20-10------2-B-Table2-11-12-23----------Now we have to load this data into seperate tables which are specified in TableDesc column of excel sheet.T1---------ID|Date|Group|Value-------------------1|Date1|A|102|Date2|A|203|Date3|A|10T2---------ID|Date|Group|Value-------------------1|Date1|B|112|Date2|B|123|Date3|B|23Same table contains data for multiple groups.--To get the table names(T1,T2,...) we maintain seperate table to store table names and TableDESCTableInfo---------ID|TableName|TableDesc----------------------1|T1|Table12|T2|Table2------Now my requirement is how to load the excel sheet data into defferent tables by getting the table names from TableName column of TableInfo Table.If the new dates entered into sheet it has to load only the new dates data into respective table.Please guide me how to do it with SSIS Package?TIA |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-05 : 01:54:01
|
| add a data flow task with excel source which connects to excel sheet. Add a conditional task to create output branches based on TableDesc field values. Connect each branch to OLEDB destination tasks which points to corresponding tables where you want to dump the data------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
learntsql
524 Posts |
Posted - 2012-05-07 : 01:39:49
|
| Thank you Visakh.I will try.TIA. |
|
|
|
learntsql
524 Posts |
Posted - 2012-05-07 : 01:56:32
|
| Hi Visakh,I am trying to work out it.Everything was fine but how to convert excel sheet date columns as rows of sql server table.all date values should be inserted in single date column.Please guide me.TIA. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-07 : 19:49:11
|
| hmm...whats the need of that. so what about other columns values? didnt understand need of merging multiple rows like that------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
learntsql
524 Posts |
Posted - 2012-05-07 : 23:57:51
|
| Let me explain more clear.I have excel data likeSno-Group-TableDesc-1May2012-2May2012-3May2012-------1-A-Table1-10-20-10------2-B-Table2-11-12-23------Now i want to load in following format--Table1Sno|Group|Date|Value----------------1|A|1-May-2012|102|A|2-May-2012|203|A|3-May-2012|10--Table2Sno|Group|Date|Value----------------1|B|1-May-2012|112|B|2-May-2012|123|B|3-May-2012|23I think its more clear now.Plz guide me.TIA. |
|
|
|
|
|
|
Excel sheet to Database data loading?