November 21, 2012 at 9:16 pm
Greetings,
I have a task of comparing a set of data, which is contained within an Excel spreadsheet with a set or records, contained within a Sql Server 2008 database table.
For this purpose I'm planning on creating a lookup table, which will have an identical structure with the primary table.
The column headers in the source Excel file are different from the column names in my DB tables.
Is there a way to use SSIS (or any other tool) to map the Excel columns to specific sql server table columns before importing Excel data?
-Eugene
November 21, 2012 at 11:32 pm
In SSIS, you have to map the columns yourself in the destination component.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 22, 2012 at 7:51 am
Thanks!
I have not used SSIS before; are you aware of any examples of how this is done?
-Eugene
November 22, 2012 at 7:55 am
Correction-
I did use Sql Server Import/Export GUI utility before.
What I'm really asking is: how to save the definition of such field mapping for the subsequent imports.
-Eugene
November 22, 2012 at 1:03 pm
eugene.goldberg117 (11/22/2012)
Correction-I did use Sql Server Import/Export GUI utility before.
What I'm really asking is: how to save the definition of such field mapping for the subsequent imports.
-Eugene
Unfortunately you can't.
You have the do the mapping yourself. Most of the time, if the column names match nicely, SSIS does this for you.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply