problems with bulk insert

• sonia-834492

  Ten Centuries

  Points: 1087

  More actions

  August 7, 2008 at 4:25 pm

  #130623

  I am trying to use bulk insert task in ssis to load data from flat file into tables but I keep getting this error. I checked all the connections and they look good.

  Error: 0xC002F304 at Bulk Insert Task, Bulk Insert Task: An error occurred with the following error message: "You do not have permission to use the bulk load statement."

  Does this mean that I need to have some sort of admin rights or something to perform bulk insert. I tried to load using t-sql for bulk insert but get the same error -- " you do not have rights"

  please help me out

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  August 7, 2008 at 8:28 pm

  #854886

  Yes... you 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)