AS400

[goofy]

Hi,

I am in a critical state..somebody pls help me.
I need to import data from a DB2/AS400 to a SQL Server7.0
I have no knowledge of DB2/AS400.

Anybody aware of a solution, pls let me know asap.

Thanks

 

[quatermass]

Hi,

I would suggest that you set up an ODBC connection using something like Client Access.

This will need to have the librarys you need defined within it.

You can then use a DTS package with the source being the ODBC driver and the destination being the SQL Server.


Hope it is of some help


Kevin **************************************************************
The difference between fiction and reality is that fiction has to make sense.
**************************************************************

 

[goofy]

Thanks, but i am not very clear
Where should the ODBC be set up, in the AS400 or the SQL Server m/c

 

[arrowhouse]

You can use DTS. Set the ODBC up on the SQL server.

 

[goofy]

Thanks a lot, shall try.