Transferring Data Between SQL2005 and DB@ using SSIS

Last Post 17 Mar 2006 06:17 AM by kolson. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
kolson
New Member
New Member

--
17 Mar 2006 06:17 AM
I started recreating a DTS package I currenlty have in SQL 2000 to send data from SQL Server to DB2 Mainframe. I'm creating a DTS/SSIS package from scratch on my 2005 test server, and didn't find a way to create a Data Flow Destination for my DB2 connection. I'm trying to send data from SQL Server to DB2 mainframe directly. I've heard that I may need to install Host Integration Server to create my connection to send data to DB2. I looked at the product - a lot of product and $$$$. I also created a DTS package on SQL 2000 that connected my SQL 2005 server to DB2 and successfully ran and transferred data. My questions to the world: What are other companies with DTS jobs transferring data between SQL and DB2 doing for SQL 2005? Are there any other products/workarounds available to get SSIS to connect to DB2 to send data to DB2 from SQL? Is anyone else using the SQL 2000 DTS "workaround" to transfer data between SQL 2005 and DB2? Any and all help or feedback greatly appreciated!
You are not authorized to post a reply.

Acceptable Use Policy