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 |
|
aksana
Starting Member
13 Posts |
 Posted - 2008-08-11 : 03:39:59
|
| hi, everyone.At last I installed SSIS and BIDS on ServerMachine.Then I have a problem inserting excel data into DB.Im trying to insert Excel date to 2 tabels.but I dont know how to insert into 2 tables,,,I did for single table. These are a excel and tables.Excel: 1 sheet4 culomns(column1,column2,column3,column4)DB: TBL_one: 5 columns(id[auto_increment],col1,col2,col3,col4)TBl_two: 5 columns(id[auto_increment],c1,c2,c3,c4)I would like to insert like this below.column1:col1 @TBL_onecolumn2:col2 @TBL_onecolumn3:c3 @TBL_twocolumn4:c4 @TBL_twodoes someone know how to do that?when I was trying to do this, I could find the GUI to do table mapping. I found the column one.if you do, could you please tell me???thank you, aksana |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-11 : 03:59:59
|
| I think what you could do is to transfer the excel data as is to a staging table and then use sql command task to transfer required columns to your two tables seperately. |
 |
|
|
aksana
Starting Member
13 Posts |
Posted - 2008-08-12 : 02:13:24
|
| hi, visakh16thanks for replying.As you said "transfer the excel data as is to a staging table", how do I do that????The truth I dont know how to use whatever in the tool box.Do I have to create a staging table??If you know some good web site telling how to use BI Development studio, could you please tell me?? thank you, aksana |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
|
|
|
|
|
|
|
Inserting Excel data to DB [:(]