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 |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2012-03-21 : 16:41:46
|
| My goal is to load data from an particular tab in an excel 2003 workbook into sql server 2008 r2 standard edition using SSIS. I am wondering if SSIS can go to a particular tab in the excel workbook, save all the data from that tab into a text file? The SSIS package when then take the data from the text file and use sql to load the data into sql server. If this is possible, can you tell me and/or point me to a reference that would show me how to accomplish this goal?The following is the problem I am currently having with the excel file received from the customer:1. column headings are not compatible with sql server,2. lots of columns are hidden, and3. and there are links in the excel that point to references that are worthless by the time I get the workbook from the customer. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-03-22 : 03:26:53
|
| You can read excel-files (and specify which tab to read) just fine in SSIS but the more complex the excel-file is the more problems you will have reading it. But it's better if you try it yourself, the GUI is quite simple and the process of the Import/Export wizard is pretty close to SSIS: Right-click your database - All tasks -> Import data and go from there.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
 |
|
|
|
|
|
SSIS load data into sql server