Click here to Skip to main content
15,879,047 members
Home / Discussions / Database
   

Database

 
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 
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 
Ravikiran72p wrote:
Is there any solution in Sqlserver or ssis or .NET solution to identify Generic Columns of excel(xls) and map to Sqlserver Table correctly.


Create an "adaptor" (concept rather than a specific type of implementation) specific to each vendor. I suggest STRONGLY that you use extensive error checking on such an adaptor because that is the only way you will detect when they change the format.

The vendor files are delivered to a vendor specific folder and that is used as a key to determine which adaptor is used to process them.

The adaptor could be written in either SQL or C#. I would choose C# because it provides more flexibility for this sort of operation. Note that a C# solution need not go directly to the database. In can just output a file, with a fixed known format, which is then used as an import file to SQL Server.

The adaptors should also have error reporting, logging is good, to report on failed conversion attempts, as well as when successful ones ran.
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 
AnswerRe: Trouble restoring a mysql database Pin
Bernhard Hiller22-Apr-13 21:33
Bernhard Hiller22-Apr-13 21:33 
GeneralRe: Trouble restoring a mysql database Pin
savedlema1-May-13 23:44
savedlema1-May-13 23:44 
QuestionBack up database Error Pin
sara-setare20-Apr-13 21:37
sara-setare20-Apr-13 21:37 
AnswerRe: Back up database Error Pin
Mycroft Holmes21-Apr-13 0:48
professionalMycroft Holmes21-Apr-13 0:48 

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.