Import Data from AS400 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Import Data from AS400

Author

Topic

rafms
Starting Member

1 Post

Posted - 2007-07-01 : 08:00:32

Hello,
I have de same problem that you have to get data from AS/400 to SQL Server 2005 using the SQL Server Import and Export Wizard.
Did you successfully? If yes how please?

I have used:
IBM DB2 UDB for iSeries IBMDA400 OLE DB Provider,
IBM DB2 UDB for iSeries IBMDARLA OLE DB Provider,
IBM DB2 UDB for iSeries IBMDASQL OLE DB Provider,
Microsoft OLE DB Provider for DB2

Regards
Rui Martins Santos

RMS

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-01 : 20:22:37

What's the problem? Try create odbc dsn to db/400 and load data with oledb provider for odbc drive.

vasu4us
Posting Yak Master

102 Posts

Posted - 2007-07-03 : 11:54:35

If you are creating a packag to do that. then i suggest using a
.net Provider for oledb\ibm db2 udb for iseries IBMDA400 oledb provider - for the connection and
data reader source to extract and then a target.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources