Sql Server Integration Services
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 ] 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: ......
Some useful SSIS