Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQLOLEDB Provider for DB2/AS400 BIG PROBLEM ! HELP !

19 views
Skip to first unread message

Joe ALVES

unread,
Jul 27, 2009, 7:47:57 AM7/27/09
to
Hello to everybody !

i've a big big problem !

i've a SSIS 2008 Project with as data source a AS/400 DB2 database, my
destination is a SQLServer 2008 database,

i have a simple package wich truncate a table in my sql database and then
start � simple dataflow

OLEDB to OLE DB

the data flow is just a select * from a DB2 Table, and insert enerything in
the same table in SQLserver

Averything is OK for many ttables, but i have some tables nammed for exemple
: "F�VCOUM","F�VSTOCK" and for these tables (wich name contains character
'�') unable to define the data transfert with the OLEDB Provider !
it runnings well with the "Iseries DB2 Provider for ADO.net" but with this
connector i've a lot of Timeout problemes, even with the tables wich present
"normal" names, without accent !


Thank for your help !!!

Joe

0 new messages