Solved

SSiS integration Package

Posted on 2011-03-02
2
1,250 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 17

Accepted Solution

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

Author Closing Comment

by:Amanda Walshaw
ID: 35024416
exactly right
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
convert null in sql server 12 57
Parse this column 6 35
Enabled trace flag 4135 or 4199 - SQL SERVER 2 24
Need to create and populate a column map table 5 19
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

733 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