Hi,

I am asked to help a customer writing data to a table on an iSeries system.

There is no ODBC source nor target in SSIS. But he can read using the
DataReader Source via ODBC.

But for writing? The DataReader Target only goes to memory. And what I am
supposed to do then?

Isn't there anything that writes to a database table other than SQL Server,
which I can use via ODBC?

Any feedback helps,
Helmut

PS: OLEDB might be a solution but unfortunately does not work for them.

Helmut:

Have you tried Microsoft's OLE DB Adapter for DB2? I have used it
extensively for reading data from an IBM AS 400 box. I bet it works good for
writing as well.

You will find a link to it under the SQL 2005 Feature Pack site:
http://www.microsoft.com/downloads/d...displaylang=en

HTH

--
Todd Chittenden


"Helmut Knappe" wrote: