Import AS400 Files into MS-SQL Server

tommanntmaPosted on August 10, 2023 Posted in AS400 — No Comments ↓

using SSMS Server Import and Export Wizard

Step-by-Step using the SSMS SQL Server Import and Export Wizard to import AS400 files into SQL Server tables. Note: If you haven’t already done so, see my instructions to correct the IBM Data Providers that are used by the Wizard (Correcting the IBM Data Provider Mapping Files ).

Figure 1 – After selecting the Source, click properties to set the connection information.

Note: Test both IBMDA400 and IBMDASQL for speed. In my tests, IBMDASQL is much, much faster.

Figure 2 – after entering the connection information, click the ALL tab to set the default Libraries.

Figure 3 – Edit Mappings to review translations and PREVIEW to see a sample of translated results.

Figure 4 – Optionally save the SSIS package to run at a later time.

Tagged with: AS400, IBM Data Provider, Import, iSeries, SQL, SSMS

Leave a Reply Cancel reply