Monday 15 October 2007

SSIS and RDB

Hi,

Facing some problems with the connectivity towards RDB, we were looking towards solutions

Problems

  • Schema information did not appear in SSIS wizards/Tools. For example character columns were represented as nvarchar (0).
  • Precision with numeric columns

Alternatives

After scanning the Internet for solutions, we came up with following alternatives
  • Buy a OLE-DB driver for RDB (Attunity)
  • Emulate RDB as an Orcale Database and use the OLE-Db driver for Oracle
  • New ODBC driver for RDB (3.0) from Oracle.

Solution

Fortunately a third option worked for us (free !)

Check out
http://www.oracle.com/technology/software/products/rdbodbc/index.html

Regards,

Alexander

3 comments:

Do my homework said...

If you need programming help, try new online services. They are actually great.

Taylor Bara said...

Are you looking for a compare and contrast topics? I've collected some here https://paperovernight.com/blog/compare-contrast-essay-topics

Anonymous said...

The prices are really very democratic, especially if you write my annotated bibliography for me consider that the work will be done by specialists with extensive teaching experience and scientific degrees. You can check the exact amount of the order with the manager during checkout.