In my past experience (admittedly with an old AS/400 version and a dysfunctional IT team), the only reliable way to get data out of an AS400 was to use one of the supplied AS/400 windows client tools to dump it down to a text file and then load the text file into SQL Server. This was quite some time ago - some technical aspects may have changed since then.