Click here to Skip to main content
15,900,973 members
Home / Discussions / Database
   

Database

 
QuestionSSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 19:47
Richard.Berry10030-Apr-13 19:47 
AnswerRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 21:56
professionalGuyThiebaut30-Apr-13 21:56 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 22:16
Richard.Berry10030-Apr-13 22:16 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 22:43
professionalGuyThiebaut30-Apr-13 22:43 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry10030-Apr-13 23:18
Richard.Berry10030-Apr-13 23:18 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
GuyThiebaut30-Apr-13 23:34
professionalGuyThiebaut30-Apr-13 23:34 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry1001-May-13 0:10
Richard.Berry1001-May-13 0:10 
QuestionGeneric column mapping Pin
Ravikiran72p30-Apr-13 1:57
Ravikiran72p30-Apr-13 1:57 
Hi,

I have been asked solution for this.

I have Vendors where i get different excel file (diffrenct structure) from different vendor.

Vendor1 excel file
------------------
Name, Address, Age

Vendor2 Excel file
------------------
CandidateName, PhysicalAddress, Age

what ever Header Names but meaning is same.

Order of Headers are may vary different...

but i need to map in Sqlserver with correct mapping means i have table like (CandidateName,CandidateAddress,Age).... Here i need to store correct data columns which are mapped from above two excels.

Is there any solution in Sqlserver or ssis or .NET solution to identify Generic Columns of excel(xls) and map to Sqlserver Table correctly.

Thanks,
Ravikiran
AnswerRe: Generic column mapping Pin
Eddy Vluggen30-Apr-13 9:49
professionalEddy Vluggen30-Apr-13 9:49 
AnswerRe: Generic column mapping Pin
Mycroft Holmes30-Apr-13 13:56
professionalMycroft Holmes30-Apr-13 13:56 
AnswerRe: Generic column mapping Pin
GuyThiebaut30-Apr-13 21:49
professionalGuyThiebaut30-Apr-13 21:49 
AnswerRe: Generic column mapping Pin
jschell1-May-13 8:34
jschell1-May-13 8:34 
QuestionMariaDB on Linux Pin
mbadi27-Apr-13 10:57
mbadi27-Apr-13 10:57 
QuestionError on SQL server join Pin
DeveloperLife201526-Apr-13 13:12
DeveloperLife201526-Apr-13 13:12 
AnswerRe: Error on SQL server join Pin
s_magus26-Apr-13 17:41
s_magus26-Apr-13 17:41 
AnswerRe: Error on SQL server join Pin
AANIL DHAKAD8-May-13 19:17
AANIL DHAKAD8-May-13 19:17 
QuestionSQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC26-Apr-13 12:37
PrissySC26-Apr-13 12:37 
AnswerRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
Mycroft Holmes26-Apr-13 13:01
professionalMycroft Holmes26-Apr-13 13:01 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC27-Apr-13 1:39
PrissySC27-Apr-13 1:39 
AnswerRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
jschell27-Apr-13 11:32
jschell27-Apr-13 11:32 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC28-Apr-13 1:41
PrissySC28-Apr-13 1:41 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
Mycroft Holmes28-Apr-13 12:49
professionalMycroft Holmes28-Apr-13 12:49 
AnswerAttached not seen over network still - will try ID values but .... Pin
PrissySC7-May-13 7:07
PrissySC7-May-13 7:07 
QuestionHow do I get the SSRS Report Mgr to work with a custom security extension? Pin
brandon schave23-Apr-13 6:31
brandon schave23-Apr-13 6:31 
QuestionTrouble restoring a mysql database Pin
savedlema22-Apr-13 7:21
savedlema22-Apr-13 7:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.