AS400 exporting data to SQL via DTS

Question

question

EddieWebb asked Jul 1, '10

AS400 exporting data to SQL via DTS

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

sql-server-2005 dts error-handling

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-07-01T23:34:03Z

Jay D answered Jul 1, '10

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.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question