Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2012 Forums  SSIS and Import/Export (2012)  import form Firebird via ODBC

Author  Topic  humercab Starting Member 1 Post Posted - 2013-10-30 : 09:25:47 Hello! I'm trying to import one table from firebird to SQL 2012 64 bit. I made ODBC and it is working. In Visual studo 2012 I made a ssis package and if I run it it is working. But when I create job in sql agent it says: Message Executed as user: SUMIDASQL\Administrator. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 11:22:56 AM Error: 2013-10-30 11:22:58.04 Code: 0xC0014020 Source: Package Connection manager "jantar64.sysdba" Description: An ODBC error -1 has occurred. End Error Error: 2013-10-30 11:22:58.04 Code: 0xC0014009 Source: Package Connection manager "jantar64.sysdba" Description: There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server. End Error Error: 2013-10-30 11:22:58.04 Code: 0x0000020F Source: Data Flow Task ODBC Source [2] Description: The AcquireConnection method call to the connection manager jantar64.sysdba failed with error code 0xC0014009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2013-10-30 11:22:58.07 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: ODBC Source failed validation and returned error code 0x80004005. End Error Error: 2013-10-30 11:22:58.07 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2013-10-30 11:22:58.11 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:22:56 AM Finished: 11:22:58 AM Elapsed: 1.232 seconds. The package execution failed. The step failed. What is wrong? job is excetuded in 32 bit mode and package is made in 32 bit. Tryed also 64 bit..result is the same..