Please please please can some help me im having a really hard time trying to Write data back into my AS400 from a data transformation on my SQL server. Basically i can export data fine using the Iseries ODBC connection but when trying to push databack it comes up with the following error when i have the Transform Data task property windo open??
the error is as follows:
"HResult of 0x80040e37 (-2147217865) returned Unexpected error occured. An error result was returned without an error messege"
If anyone can give me some advise on this then that would be great. The purpose that im writing back to AS400 is to prompt a flag
asked Jul 01 '10 at 04:17 PM in Default
After some searching though the sql server forums on the web, others have similar issues related to the OLEDB Destination and using the Fast Load option. I'm not certain what's going on, but this may be related.
"I would suspect your initial issue is a similar problem with bcp. The Fast Load option for an OLE DB Destination component is a bulk insert. I would assume (I have never tried it) that a bulk copy command cannot insert into a table on another server using a 4-part name. Remember, when you use a synonym, that is really what is happening. Don't use the fast-load option and see what happens." found at: http://www.sqlservercentral.com/Forums/Topic518831-148-1.aspx
Hope this helps.
answered Jul 01 '10 at 11:34 PM