SSiS integration Package

getting the following erorr, the user id using the package has full insert, update, execute etc rights.

Canot execute the Builk insert package, can anyone point me in the right direction

SSIS package "Packagetest.dtsx" starting.
Error: 0xC002F304 at Account Hierarchy CSV, Bulk Insert Task: An error occurred with the following error message: "You do not have permission to use the bulk load statement.".
Warning: 0x80019002 at Packagetest: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: Account Hierarchy CSV
SSIS package "Packagetest.dtsx" finished: Failure.
Amanda WalshawBusiness Solutions AnalsystAsked:
Who is Participating?
dbaSQLConnect With a Mentor Commented:
your user needs bulkadmin (or sysadmin) to do bulk insert
Amanda WalshawBusiness Solutions AnalsystAuthor Commented:
exactly right
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.