By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,711 Members | 2,158 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,711 IT Pros & Developers. It's quick & easy.

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

P: n/a
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(OdbcHa ndle hrHandle,
RetCode r
etcode)
at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcCo nnection
connection, Odb
cConnectionString constr, OdbcEnvironmentHandle environmentHandle)
at
System.Data.Odbc.OdbcConnectionFactory.CreateConne ction(DbConnectionOption
s options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection own
ingObject)
at
System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbC
onnection owningConnection, DbConnectionPoolGroup poolGroup)
at
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
ow
ningConnection)
at
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
ou
terConnection, DbConnectionFactory connectionFactory)
at System.Data.Odbc.OdbcConnection.Open()
at
Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetM anagedConnection(String
assemblyQualifiedName, String connStr, Object transaction)
at
Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnec tionManager90.AcquireCon
nection(Object pTransaction)
at
Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceA dapter.AcquireConnection
s(Object transaction)
at
Microsoft.SqlServer.Dts.Pipeline.ManagedComponentH ost.HostAcquireConnectio
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

Nov 28 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.