Connecting to Double Byte Progress (MFG-PRO) databases from SSIS...

Hello

We use MFG-PRO as our ERP system which in turn uses Progress
databases. In the old version of SQL 2000, using DTS packages, we used
to set the code page via command prompts and execute DTS packages
within that command prompt to fetch data from our double byte ERP
databases. In SSIS, we are able to connect and fecth data from NON
Double Byte databases, however, when we set the code page first and
execute via a command prompt the SSIS package, we get the following
error. We used a ADO.NET connection to connect to our Source ERP
System. Appreciate any help.

Thanks

Jagannathan Santhanam

Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 8:09:26 AM
Progress: 2007-11-28 08:09:26.93
Source: Data Flow Task 1
Validating: 0% complete
End Progress
Error: 2007-11-28 08:09:27.15
Code: 0xC0047062
Source: Data Flow Task 1 DataReader Source [1]
Description: System.Data.Odbc.OdbcException: ERROR [HYC00]
[DataDirect][ODBC
PROGRESS driver]Optional feature not implemented.
ERROR [HY000] [DataDirect][ODBC PROGRESS driver][PROGRESS]-219901
ERROR [IM006] [DataDirect][ODBC PROGRESS driver]Driver's
SQLSetConnectAttr faile
d.
ERROR [HYC00] [DataDirect][ODBC PROGRESS driver]Optional feature not
implemented
..
ERROR [HY000] [DataDirect][ODBC PROGRESS driver][PROGRESS]-219901
ERROR [IM006] [DataDirect][ODBC PROGRESS driver]Driver's
SQLSetConnectAttr faile
d.
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle,
RetCode r
etcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection
connection, Odb
cConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbCo nnectionOption
s options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection own
ingObject)
at
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooled Connection(DbC
onnection owningConnection, DbConnectionPoolGroup poolGroup)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnection(D bConnection
ow
ningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(D bConnection
ou
terConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at
Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConn ection(String
assemblyQualifiedName, String connStr, Object transaction)
at
Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManage r90.AcquireCon
nection(Object pTransaction)
at
Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.Acq uireConnection
s(Object transaction)
at
Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAc quireConnectio
ns(IDTSManagedComponentWrapper90 wrapper, Object transaction)
End Error
Error: 2007-11-28 08:09:27.16
Code: 0xC0047017
Source: Data Flow Task 1 DTS.Pipeline
Description: component "DataReader Source" (1) failed validation
and returned
error code 0x80131937.
End Error
Progress: 2007-11-28 08:09:27.16
Source: Data Flow Task 1
Validating: 33% complete
End Progress
Error: 2007-11-28 08:09:27.16
Code: 0xC004700C
Source: Data Flow Task 1 DTS.Pipeline
Description: One or more component failed validation.
End Error
Error: 2007-11-28 08:09:27.16
Code: 0xC0024107
Source: Data Flow Task 1
Description: There were errors during task validation.
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 8:09:26 AM
Finished: 8:09:27 AM
Elapsed: 0.859 seconds