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-22 : 15:42:02
|
| I am trying to determine what is the best way to setup an SSIS package for sql server 2008 r2. I am getting an excel 2003 workbook from a customer where I will obtain data from a tab in the middle of the workbook. The columns will be in the same order, but I might have unexpected data where I do not expect this to occur. My company wants me to load whatever comes from the customer into the sql server database.Thus I am thinking of opening the excel workbook to the tab I want. I would then save the file in a 'text' format as tab delimited or possibly as a comma delimited file. I then will have the SSIS package work with the Text file or the comma delimited file to extract the information.I am thinking of this option instead of working with the excel spreadsheet directly to avoid any unhidden columns, grouped columns, and/or links to external files.What do you think is the best way to start the SSIS package to work with and why? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-22 : 15:44:42
|
| your approach sounds ok but conversion part from excel to text file you might have to make use of excel macro or VBA code. You can have SSIS package look for text file and parse and get data from it to a sql table. You can set up a shared folder where text file gets saved and ssis will monitor the folder and pick the file once present------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-03-27 : 01:25:05
|
| depending on how the data is used, dynamic destination table creation based on columns sent might be your only route<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
best way to setup ssis package