Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2012 > BOOK: Professional Microsoft SQL Server 2012 Integration Services
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional Microsoft SQL Server 2012 Integration Services
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2012 Integration Services by Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock; ISBN: 978-1-1181-0112-4
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Microsoft SQL Server 2012 Integration Services section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old February 18th, 2013, 10:46 PM
Registered User
Points: 11, Level: 1
Points: 11, Level: 1 Points: 11, Level: 1 Points: 11, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default 0x8000405 Error when running Bulk Insert Task

I got this error:
Error: 0xC0202009 at BulkInsertTask, Connection manager "localhost.AdventureWorksDWDenali": SSIS Error Code

DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Login failed for user 'servername\myusername.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description:

"Cannot open database "AdventureWorksDWDenali" requested by the login. The login failed.".
Error: 0xC002F304 at Load Zip Codes, Bulk Insert Task: An error occurred with the following error message: "Exception from HRESULT: 0xC0202009".
Task failed: Load Zip Codes
------------------------------------------------------------------------------------------------
I looked up in the solution and found this:

Resolution:

To resolve this issue, you must change the permissions for the Temp directory of the SQL Server Agent Service startup account. Grant the Read permission and the Write permission to the SQL Server 2005 Agent proxy account for this directory.

I am not sure how to do this and would appreciate any help! Thanks

Emily
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
bulk insert hymavathy_kr VB Databases Basics 1 May 17th, 2007 07:47 AM
Error Handling in Bulk Insert starnet SQL Server 2000 0 October 12th, 2006 03:27 AM
Bulk Insert luma SQL Server DTS 1 July 13th, 2005 01:48 AM
bulk insert error - help needed!! fgeorge SQL Server 2000 2 May 25th, 2004 04:38 PM



All times are GMT -4. The time now is 11:07 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.