SSIS

Sql Server Integration Services

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' co

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: ......