My Techie Blog

  Home  |   Contact  |   Syndication    |   Login
  110 Posts | 5 Stories | 406 Comments | 0 Trackbacks

News

Article Categories

Archives

Post Categories

Image Galleries

ADO.NET

Ajax

API/WebServices

ASP.NET Resources

BizTalk Server

Blogs I read

Free Books

How to

iOT

JavaScript

JQuery

JSLink - SharePoint

JSON

LINQ

Misc

Mobile BI

MS Business Inteliigence

Reporting Services

Responsive/MVC ASP.NET

SEO

Sharepoint Resources/Tools

SharePoint 2010 Branding

SharePoint 2010 Videos

SharePoint 2013

SharePoint Online

SilverLight

SPServices

SQL Server

Sql Server 2012

SSIS

Web Optimization Tools

Web Performace Tools

Windows 8

Windows Azure

Windows Azure

Windows Phone

WorkFlows

WSS V3

xml

I was trying to export data from a txt/csv file to sql server table.
After setting up the package and executed it .It worked if the sql server destination is on the same server were i ran the package from.

But when i tried  to export the data to a different server i get the error:-

[SQL Server Destination [2625]] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E14  Description: "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT              ' could not be opened. Operating system error code 2(error not found). Make sure you are accessing a local server via Windows security.".

After doing some search i found this great article.
Which stated that 
SQL Server Destination that cannot access a remote box because BULK INSERT will not be able to access the memory space of a remote machine.
So the way to go is to use OLEDB Destination.

One more thing though is you could setill get error after switching to OLE DB Desitnation and you might need to re map your columns to get it to work :( especially if it was set as SQL server Destination.

Tip: Make sure you use SQL SERVER Authentication when using the remote option

Hope that saves your time.
posted on Tuesday, July 21, 2009 11:20 PM

Feedback

#  hresult:0x80040e14 7/16/2013 7:09 PM ganesh
when i try create a oracle procedure or function through ssis (execute sql task) i am getting error hresult:0x80040e14.i don't understand exactly what is the error. how can resovle it pls help me.

thanks.

Post A Comment
Title:
Name:
Email:
Comment:
Verification: