ODBC driver doesn't work in SSIS package on Win2012 Server 64-bit [ODBC164]
firebird-automations opened this issue · 5 comments
Submitted by: Shakh Viktor (shakhviktor)
Votes: 1
I created SSIS package for loading data from Firebird 2.5 table with field type varchar(20), charset win1251
to table on ms sql server with field type nvarchar(20).
ADO Net Source uses Firebird_ODBC_2.0.1.152_x64 driver,
and OLE DB Destination uses Microsoft OLE DB Provider for SQL Server.
The result of data flow task is empty field in the table on ms sql server side.
Modified by: Shakh Viktor (shakhviktor)
description: I'm created SSIS package for loading data from Firebird 2.5 table with field type varchar(20), charset win1251
to table on ms sql server with field type nvarchar(20), the result of data flow task is empty field on ms sql server side.
ADO Net Source uses Firebird_ODBC_2.0.1.152_x64 driver.
And OLE DB Destination uses Microsoft OLE DB Provider for SQL Server.
=>
I created SSIS package for loading data from Firebird 2.5 table with field type varchar(20), charset win1251
to table on ms sql server with field type nvarchar(20).
ADO Net Source uses Firebird_ODBC_2.0.1.152_x64 driver,
and OLE DB Destination uses Microsoft OLE DB Provider for SQL Server.
The result of data flow task is empty field on ms sql server side.
summary: ODBC driver doesn't work in SSIS package on Win2012 64bit Server => ODBC driver doesn't work in SSIS package on Win2012 Server 64-bit
Modified by: Shakh Viktor (shakhviktor)
description: I created SSIS package for loading data from Firebird 2.5 table with field type varchar(20), charset win1251
to table on ms sql server with field type nvarchar(20).
ADO Net Source uses Firebird_ODBC_2.0.1.152_x64 driver,
and OLE DB Destination uses Microsoft OLE DB Provider for SQL Server.
The result of data flow task is empty field on ms sql server side.
=>
I created SSIS package for loading data from Firebird 2.5 table with field type varchar(20), charset win1251
to table on ms sql server with field type nvarchar(20).
ADO Net Source uses Firebird_ODBC_2.0.1.152_x64 driver,
and OLE DB Destination uses Microsoft OLE DB Provider for SQL Server.
The result of data flow task is empty field in table on ms sql server side.
Modified by: Shakh Viktor (shakhviktor)
description: I created SSIS package for loading data from Firebird 2.5 table with field type varchar(20), charset win1251
to table on ms sql server with field type nvarchar(20).
ADO Net Source uses Firebird_ODBC_2.0.1.152_x64 driver,
and OLE DB Destination uses Microsoft OLE DB Provider for SQL Server.
The result of data flow task is empty field in table on ms sql server side.
=>
I created SSIS package for loading data from Firebird 2.5 table with field type varchar(20), charset win1251
to table on ms sql server with field type nvarchar(20).
ADO Net Source uses Firebird_ODBC_2.0.1.152_x64 driver,
and OLE DB Destination uses Microsoft OLE DB Provider for SQL Server.
The result of data flow task is empty field in the table on ms sql server side.
Commented by: Dirk Kietzer (kietzer)
Hi,
i have the same problem with the firebird odbc driver.
Is there allready any solution?
BR
I don't think Win2012 Server is actual in 2024)
You may reopen it if needed.