in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » SSIS » Oracle (RSS)

Browse by Tags

  • NUMBER without Precision

    This week I experienced an annoying incompatibility between SQL Server 2005 and Oracle 9.2.2. If a column in Oracle has a NUMBER data type without explicitly set precision (like NUMBER(10)) then SSIS is not able to handle it when using an OLE DB Connection Manager. The error message is this: Error at...
    Posted to MartinIsti MS BI blog (Weblog) by MartinIsti on Tue, Apr 28 2009
  • Oracle DATE vs SQL DATE

    During the development of a simple (or so we thought ) SSIS task a strange error came up: we had a dbtimestamp column from Oracle which we had to load into a SQL Server ( 2005! ) table. It was a transaction date so by default there shouldn't have been any problem with it. By default. But life's...
    Posted to MartinIsti MS BI blog (Weblog) by MartinIsti on Tue, Mar 31 2009
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems