July 23, 2012 at 3:23 pm
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14.
An OLE DB record is available. Source: "Ifxoledbc" Hresult: 0x80040E14 Description: "E42000: (-201) A syntax error has occurred.".
(Microsoft Visual Studio)
Trying to load data into one sql server tabler by joining couple of tables in informix.
Please let me know if anyone is aware of this error..
Thanks in advance!
July 23, 2012 at 3:29 pm
What driver are you using to connect to the informix database?
See if this article is of help.
http://jasonbrimhall.info/2010/07/23/a-little-dance-with-ssis-and-informix/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 23, 2012 at 4:07 pm
IBM Informix OLEDB Provider
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply