Splitting Table Column on Delimiter

Question

Splitting Table Column on Delimiter

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

antonio.collins SSCrazy Eights Points: 9600 More actions · Answer 1

Btw, BCP's err files (-e) filter all rows for a failed batch, not just the offending row(s). And using too large a batch size can cause issues with the log even if the db is set for simple recovery mode.

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 2

Jeff Moden (4/1/2008)
To add to what Matt just said... if the server logs in as a domain super-user that can see all the machines and at least some "shares", using a little Dynamic SQL in conjuction with BULK INSERT will blow the doors off of any other type of import. If you have the luxury of being able to use BCP, BCP will find bad rows and store them in a "bad file" so you can repair them later without having the main import fail. It's not quite as fast as BULK INSERT but is still way faster than DTS. Rumor has it that SSIS also has a "Bulk Insert" method but I don't know if it'll check for bad rows "auto-magically".

SSIS has the ability to redirect any error rows, or just ignore them. So - you can capture the errors, and possibly do something else with them.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 3

Thanks Matt. Learned something new today! 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

phairston Newbie Points: 6 More actions · Answer 4

phairston

Newbie

Points: 6

July 31, 2008 at 2:50 pm

#851546

Lowell,

phairston Newbie Points: 6 More actions · Answer 5

Lowell,

You may want to try opening the data file in Excel and checking tab delimiter. Hope this info helps.

Now, maybe you can help me. I'm looking for the data base with the dam and reservoir information. Is it a public access data base? And if so, can you give me some guidance on how to access it?

Thanks,

Peggy