SSIS Export to iSeries table -- sql server dts

Helmut Knappe
12/15/2006 12:00:00 AM

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.

Todd C
12/15/2006 5:00:02 AM

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/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en

HTH

--
Todd Chittenden

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : SSIS Export to iSeries table