Mainframe DB2

[Sudha]

Hi all,
I am new to SSIS, my source system is Mainframe DB2 and target is SQL Server2005.
How to transform data from Mainframe DB2 to Sql server?
Can we use Mainframe DB2 directly as source?
Is any third party tool required to transform the data from Mainframe DB2?

Thanks,
Pratha

From http://www.developmentnow.com/g/103_2006_6_0_0_0/sqlserver-dts.ht

Posted via DevelopmentNow.com Group
http://www.developmentnow.com/g/

[Todd C]

"Mainframe" DB2, does that mean AS400 DB2? If you are using SQL Enterprise,
you can download Microsoft's OLE DB connector for IMB DB2, available in the
SQL Server 2005 Feature pack that came out November 2005 (sorry, don't have
the link).
--
=====
Todd C

Post by Sudha
Hi all,
I am new to SSIS, my source system is Mainframe DB2 and target is SQL Server2005.
How to transform data from Mainframe DB2 to Sql server?
Can we use Mainframe DB2 directly as source?
Is any third party tool required to transform the data from Mainframe DB2?
Thanks,
Prathap
From http://www.developmentnow.com/g/103_2006_6_0_0_0/sqlserver-dts.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/