Connect Navision Native DataBase FDB file from Sql SSIS 2005

liyasker

I am working MS SqlServer 2005 SSIS SP3 and I have Installed N ODBC 4.0 SP1 my machine to connect the Navision Native database FDB file.

I want to write the ETL mapping in SSIS

Source : NODBC DataSource (Configured connection with FDB File)

Destination : SqlServer Table

Is it Feasible?

I did some work around to achieve this.

My rquirement is Conect Navision FDB File from MS sqlserver SqlServer Intergration Services(SSIS)

Work Around 1.

I Created ODBC User DSN using NODBC. And I refered this ODBC Data Source in SSIS. Test Connection is Success. But i am not able to see any table in the SSIS DataReader Source.

Work Around 2.

Using the Same "User DSN" i can connect Navision FDB from MS XL and i import the Data.

And using MS Sqlserver 2005 Import Wizard I am able to see the tables and columns But while performing the operation

i am getting this error...



"

- Validating (Error)

Messages

Error 0xc0047062: Data Flow Task: System.Data.Odbc.OdbcException
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.IDTSConnectionManager90.AcquireConnection(Object pTransaction)
at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction) (SQL Server Import and Export Wizard)

Error 0xc0047017: Data Flow Task: component "Source - Query" (1) failed validation and returned error code 0x80131937.
(SQL Server Import and Export Wizard)

Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

"

I hope that SQL Import Wizard works then it should work in SSIS DataReader Source as well . Connecting Navision FDB file from SSIS 2005 sp3 using NODBC 4.0 sp1 is Feasible?Can any one explain me to overcome?

David_Singleton

liyasker wrote:

I am working MS SqlServer 2005 SP3 and I have Installed N ODBC 4.0 SP1. Is it Fissile?

Completely off topic I know but... , its probably 20 years since I studied Nuclear and Quantum physics, and I probably forgot something over those years, ... so what is the connection between Fissile and Navision?

liyasker

Sorry it is a typo. Fissile - Feasible


Subject of last posted Question: "Connect Navision Native DataBase FDB file from Sql SSIS 2005"

Connet Navision Native Database FDB File from Sql Server Integration Service(SSIS) 2005 SP3 and using NODBC 4.0 sp1.

NODBC 4.0 sp1 will support?

Thanks