SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 import form Firebird via ODBC
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

humercab
Starting Member

Slovenia
1 Posts

Posted - 10/30/2013 :  09:25:47  Show Profile  Reply with Quote
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..
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000