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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2009-02-04 : 07:55:09
|
| I am creating an SSIS package for data migration from Excel to SQL Server tables. Details steps?? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-04 : 08:55:07
|
| use this to get data in required format on destination.http://technet.microsoft.com/en-us/library/ms141723(SQL.90).aspxso you will have excel source->unpivot transformation-> oledb destination |
 |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2009-02-05 : 03:54:05
|
| My excel input are numeric values in two columns here and if value exists in that column then i need to set column header as row here i got it from Excel---- unpivot... destinationT.I.A |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-07 : 09:47:42
|
| Cheers |
|
|
|
|
|
|
Import Excel to Table