Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2012, DB2 and SSIS Expand / Collapse
Author
Message
Posted Thursday, May 9, 2013 9:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 7:59 AM
Points: 49, Visits: 398
Greetings,
We are going to a new server (Windows Server 2012) with SQL 2012 from SQL 2005. We have the DB2 client installed and a linked server configured in order to use OpenQuery to import data, which we do using SSIS. The problem is that, in the new environment, all the string data is now being seen as Unicode. This creates a huge hassle updating the dataflow tasks in the import package by having to add a Data Conversion transform and re-map all the fields.

Does anyone intimate with the DB2 client and SQL Server 2012 know of a setting or change in the DB2 client or linked server configuration in SQL Server 2012 that might cause this change?

I am not the one who installed the client or configured the linked server and so want to pass along anything I can to our DBA folks to get this resolved.

Thanks.
Post #1451188
Posted Tuesday, May 14, 2013 11:22 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 8:39 AM
Points: 1,157, Visits: 3,259
Which DB2 client are you working with, IBM? Have you tried Microsoft's OLEDB provider for DB2?

http://www.microsoft.com/en-us/download/details.aspx?id=29100


Tommy

Post #1452735
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse