RE: Data migration DB2 for i/OS to SQL Server

See following is a year-old item
& a MC Press book.

https://www.mc-store.com/products/extract-transform-and-load-with-sql-server-integration-services?_pos=1&_sid=a888a708b&_ss=r

BTW
we use SQL Server SSIS extensively for many years for pulling data
into OLAP cubes

HTH
Gad

date: Fri, 18 Oct 2019 12:32:05 +0000
from: Matt Olson via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
subject: RE: Data migration DB2 for i/OS to SQL Server

Microsoft SQL Server Migration Assistant 8.4 for DB2:
https://www.microsoft.com/en-us/download/details.aspx?id=54254

Details on tool:
https://docs.microsoft.com/en-us/sql/ssma/db2/sql-server-migration-assistant-for-db2-db2tosql?view=sql-server-ver15

Of course you could also use the built in ETL tool that comes with SQL
Server (SSIS).

-----Original Message-----
From: Reggie Acosta <racosta@xxxxxxxxxxxxxxx>
Sent: Thursday, October 17, 2019 1:53 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: Data migration DB2 for i/OS to SQL Server

Does anyone know of any links to articles, documents, pdf's, etc. on this
subject? Tips on bulk copy and such. I haven't been able to figure out the
right incantation to get info specific enough on Google.

Thanks,
Reggie Acosta
brownjordan.com<https://www.brownjordan.com/> | brownjordaninc.com<
https://brownjordaninc.com/>
--

message: 4
date: Tue, 3 Nov 2020 10:32:03 -0500
from: Pas Palter <palterpas@xxxxxxxxx>
subject: Moving As/400 data to SQL Server

Hi- Is there a document you might have or know of, that lists the steps
required
to move data from the IBM i - over to a SQL Server? I have read that some
method includes using SSIS if this is something you have done please let me
know.
Thank you,