Bulk Insert to a temorary table

Question

Bulk Insert to a temorary table

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

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

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 1

Yes, I believe so.

--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)

jcrawf02 SSC-Insane Points: 24198 More actions · Answer 2

Jeff, BOL says this -

Permissions

Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.

If I can't convince almighty DBA to make me either, I'm screwed? Or BOL is bogus, and they can just grant me BULK INSERT on TempDB?

---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]

"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Loner SSC-Insane Points: 21279 More actions · Answer 3

Well if your DBA does not grant you permission, can you create a table and drop it after you are done ?

Dave-3000 SSCertifiable Points: 6186 More actions · Answer 4

How big is your CSV file? If it's relatively small, and you are writing an app anyway, why not just write some code in the app to suck up the PKs and write it to a base table?

There is no "i" in team, but idiot has two.

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 5

jcrawf02 (5/16/2008)
Jeff, BOL says this -
Permissions
Only members of the sysadmin and bulkadmin fixed server roles can execute BULK INSERT.
If I can't convince almighty DBA to make me either, I'm screwed? Or BOL is bogus, and they can just grant me BULK INSERT on TempDB?

You only need BulkAdmin privs...

--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)