USING SQL Server Integration Services to retrieve data from an IBM AS400

Thanks again to Jennifer Stirrup from Aspective (A Vodafone company) for writing up how she gets data into SQL Server using its in built Integration Services (SSIS) from an AS400 in this useful guide. This takes me back to my first ever BI project which was doing the same thing only with SQL Server 7…

0

SQL Server: Using SSIS to retrieve data from AS400

Using SSIS, getting data from one SQL Server to another SQL Server is straightforward enough. However, what about getting data from other non-Microsoft data sources? Here, we will discuss the integration of data from an AS400 system with SQL Server 2005, and insertion into a SQL Server 2005 data warehouse. There isn’t much documentation on…

1