Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1299
  • Last Modified:

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.
0
Amanda Walshaw
Asked:
Amanda Walshaw
1 Solution
 
dbaSQLCommented:
your user needs bulkadmin (or sysadmin) to do bulk insert
0
 
Amanda WalshawBusiness Solutions AnalsystAuthor Commented:
exactly right
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now