Click here to Skip to main content
15,902,832 members
Home / Discussions / Database
   

Database

 
AnswerRe: Bulk insert - Fewer fields than in DB Pin
GuyThiebaut10-Oct-07 7:01
professionalGuyThiebaut10-Oct-07 7:01 
I can't help with a bulk insert - however would doing an import via Enterprise Manager be an option?

I mention this because you can map fields through the import wizard and it should cover what you want to do.

Of course this is a once off option for ad-hoc jobs, but if doing a bulk insert is not absolutely necessary and this is an ad-hoc job I'd suggest looking at this option.

In Enterprise Manager it is under Tools/Data Transformation Services/Import Data...
You an also get to this via the SQL Server tab on your start menu under Import and Export Data

Hope this helps...




You always pass failure on the way to success.

QuestionCalling reports from server logged in user wise Pin
MSinha10-Oct-07 3:50
MSinha10-Oct-07 3:50 
AnswerRe: Calling reports from server logged in user wise Pin
pmarfleet10-Oct-07 4:49
pmarfleet10-Oct-07 4:49 
GeneralRe: Calling reports from server logged in user wise Pin
MSinha10-Oct-07 5:29
MSinha10-Oct-07 5:29 
GeneralRe: Calling reports from server logged in user wise Pin
pmarfleet10-Oct-07 5:37
pmarfleet10-Oct-07 5:37 
QuestionCreateQueryDef() pause needed Pin
new_phoenix10-Oct-07 3:40
new_phoenix10-Oct-07 3:40 
AnswerRe: CreateQueryDef() pause needed Pin
DQNOK10-Oct-07 5:32
professionalDQNOK10-Oct-07 5:32 
GeneralThere has got to be a more elegant way to do this... Pin
new_phoenix10-Oct-07 10:13
new_phoenix10-Oct-07 10:13 
QuestionHow to query all of the tab_name in the same database Pin
nibabug10-Oct-07 1:16
nibabug10-Oct-07 1:16 
AnswerRe: How to query all of the tab_name in the same database Pin
Krish - KP10-Oct-07 1:21
Krish - KP10-Oct-07 1:21 
AnswerRe: How to query all of the tab_name in the same database Pin
Virendrak10-Oct-07 2:25
Virendrak10-Oct-07 2:25 
AnswerRe: How to query all of the tab_name in the same database Pin
GuyThiebaut10-Oct-07 5:21
professionalGuyThiebaut10-Oct-07 5:21 
QuestionRe: How to query all of the tab_name in the same database Pin
nibabug10-Oct-07 14:11
nibabug10-Oct-07 14:11 
AnswerRe: How to query all of the tab_name in the same database Pin
GuyThiebaut10-Oct-07 21:16
professionalGuyThiebaut10-Oct-07 21:16 
Questionproblem in page indexing in Grid View Pin
ahmed_fci200610-Oct-07 0:44
ahmed_fci200610-Oct-07 0:44 
QuestionLast value in a Table Pin
BINOVAR10-Oct-07 0:18
BINOVAR10-Oct-07 0:18 
AnswerRe: Last value in a Table Pin
Aavesh Agarwal10-Oct-07 0:32
Aavesh Agarwal10-Oct-07 0:32 
GeneralRe: Last value in a Table Pin
Aavesh Agarwal10-Oct-07 0:36
Aavesh Agarwal10-Oct-07 0:36 
AnswerRe: Last value in a Table Pin
Paddy Boyd10-Oct-07 0:56
Paddy Boyd10-Oct-07 0:56 
GeneralRe: Last value in a Table Pin
Paddy Boyd10-Oct-07 1:11
Paddy Boyd10-Oct-07 1:11 
GeneralRe: Last value in a Table Pin
BINOVAR10-Oct-07 1:09
BINOVAR10-Oct-07 1:09 
GeneralRe: Last value in a Table Pin
pmarfleet10-Oct-07 2:12
pmarfleet10-Oct-07 2:12 
QuestionQuery regarding Trigger Pin
Aavesh Agarwal9-Oct-07 23:37
Aavesh Agarwal9-Oct-07 23:37 
QuestionSwap the columns values [modified] Pin
Aavesh Agarwal9-Oct-07 22:55
Aavesh Agarwal9-Oct-07 22:55 
AnswerRe: Swap the columns values Pin
Joe9-Oct-07 23:26
Joe9-Oct-07 23:26 

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.