RE: DB2/400 extracting for report purpose

I have not used SSIS for this, but depending on the amount of data and pipe speed, you might want to export locally at each site and then compress and push across the wire with something like FTP before importing to SQL server.

Regards,

[http://static.helpsystems.com/hs/email/templates/signatures-final/images/hs-logo2.png]

Richard Schoen
Director of Document Management

e. richard.schoen@xxxxxxxxxxxxxxx<mailto:richard.schoen@xxxxxxxxxxxxxxx>
p. 952.486.6802
w. helpsystems.com<http://www.helpsystems.com/>
[cid:image002.jpg@01D1A545.4C2BF250]<http://www.linkedin.com/in/richardschoen>[cid:image003.jpg@01D1A545.4C2BF250]<http://www.twitter.com/richardschoen>



I would like to grab all the data from each of the company locations into a
central reporting database then have the report formatted to group by
location so everything is in one report and sent out. I would like to use
an ETL tools like SQL Server Integration Services to extract the data and
merge them into the reporting database.

Has anyone used the SSIS with data from the IBM i, in multiple locations?
(each location has one IBM i).They pretty much want to go this route rather
than writing something on the HQ ibm i.