We help IT Professionals succeed at work.

SSIS package error on Sybase ADO NET SOUCE load in to SQL SERVER

 Attempting to import data from sybase to SQL Server. I Created a SSIS Pacakge with a ADO Net Source with Datasource connection like so  Data Source I created
and I get a test that is successful like so
 The test connection however when i try to run the package i get this error
 The error
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: component "ADO NET Source" (1243) failed validation and returned error code 0x80131937.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation.

Any help of how to get rid of this error.
Comment
Watch Question

Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Commented:
While still in Debug mode (aka ADO.NET box is red), click on the Progress button, find the line that starts with [Some Task Name] error, and copy-paste it into this question.

Author

Commented:
[ADO NET Source [1243]] Error: System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
   at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)
   at System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions)
   at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.Odbc.OdbcConnection.Open()
   at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction)
   at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction)
   at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)

Author

Commented:
the second error

[SSIS.Pipeline] Error: component "ADO NET Source" (1243) failed validation and returned error code 0x80131937.

third error
[SSIS.Pipeline] Error: One or more component failed validation.
I found the problem, the ODBC Datasources were created in 32 bit so to get to work I had to chnage debug options to 32 bit at runtime.
In the Package navigate to Project->Project properties->Debugging->Debug Options->Run64BitRuntime
set to Flase like so
 Change Debug Options to 32 bit at runtime

Author

Commented:
ODBC Datasources were created in 32 bit so to get to work I had to chnage debug options to 32 bit at runtime.