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

more ▼

asked Jul 01, 2010 at 04:17 PM in Default

avatar image

1 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jul 01, 2010 at 11:34 PM

avatar image

Jay D
128 2 3 6

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 01, 2010 at 04:17 PM

Seen: 1839 times

Last Updated: Jul 01, 2010 at 04:17 PM

Copyright 2018 Redgate Software. Privacy Policy