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 and Data Transformation Services, at least it’s easier now to find out where it’s all going wrong, but as Jenny points out it’s essential to have the right drivers and hotfixes for SSIS for this to work.