Solved

SSiS integration Package

Posted on 2011-03-02
2
1,233 Views
Last Modified: 2012-05-11
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
Comment
Question by:Amanda Walshaw
2 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
Comment Utility
your user needs bulkadmin (or sysadmin) to do bulk insert
0
 

Author Closing Comment

by:Amanda Walshaw
Comment Utility
exactly right
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now