OLE DB Provider for DB2

• juute

  SSC Enthusiast

  Points: 169

  More actions

  August 4, 2011 at 3:28 am

  #145926

  Hello everybody,

  actually we've an issue loading data from an AS/400 server in SSIS using 'Microsoft OLE DB Provider for DB2'. The only character data types we're able to receive are unicode strings, but we need non-unicode strings.

  I've just read an article that 'IBM OLE DB Provider for DB2' provides a property, where you can switch between unicode and non-unicode. Is there a similar property for 'Microsoft OLE DB Provider for DB2'?

  If there isn't, does anybody know where we can download the 'IBM OLE DB Provider for DB2'? Is this provider for free?

  We think, Data conversion tasks would take more processing time than receiving non-unicode strings directly, don't they?

  Thanks in advance

  Andre

• Meet George Jetson

  SSChampion

  Points: 11636

  More actions

  August 5, 2011 at 10:33 am

  #1364505

  This may be what you are looking for -

  http://www-03.ibm.com/systems/i/software/access/index.html

  Chris Powell

  George: You're kidding.
  Elroy: Nope.
  George: Then lie to me and say you're kidding.