March 8, 2006 at 12:16 pm
I created my DB2 connection and SQL Server connection, set up a data flow task and specified my SQL Server connection as the source, but now I'm stuck. How do I make my DB2 connection into the target? I don't see anything obvious in the Data Flow destinations - ???? I know its possible as I was sending data directly to DB2 in DTS packages, but my packages when converted turned into ????? crud. All help greatly appreciated.
March 13, 2006 at 8:00 am
This was removed by the editor as SPAM
March 15, 2006 at 3:12 pm
I am working on copmletely rewriting DTS 2000 to SSIS package from the scratch. I have been dealing with sending data to DB2/AS400. I contacted with microsoft support and they said that there is NO OLEDB support for DB2. In addition there is NO ODBC destination support that takes advantage of using ODBC for DB2.
Therefore,
I installed Host Integration Server (HIS) 2004 that provides OLEDB for DB2. With this OLEDB support, i can create OLEDB destination. Seems to work fine. The question is that you have to download an evaluation version of HIS 2004 OR you have to purchase a license. This is Microsoft's trick.
March 17, 2006 at 8:51 am
I glanced at the HIS site - Yikes! Quite a product and a pricetag for it too! Any difficulties or recommendations for someone who has never tackled it before? Does it have to be installed on each SQL 2005 server that is connecting to DB2? Because the product has a couple features that handle security, etc, it may end up being a long time before we get it approved to even test.
March 17, 2006 at 11:11 am
Well, Krista -
let me recommend you to this better site which has lots of discussion on using DB2 inside SSIS. You should be able to find helpful info there.
Let me know if you can access it.
-Steve
March 17, 2006 at 11:17 am
Yes, you have to install HIS on each PC that runs instance of SQL servers. If you do not run clustered SQL server, it can be simple to install and use it. It can be quite complex to install HIS on clustered box. You may have to get a Microsoft HIS support for clustered SQL server.
Secondly, if you use (distributed) transaction enabled for your packages, you do need a license. I am not sure if OLE2DB from the evaluation version supports distributed transaction.
-Steve
March 27, 2006 at 5:29 pm
we have had the same problem with moving data into MySQL with ODBC links. What we have had to do was use a "Script Component as a Destination.
Craig
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply