Browse by Tags

All Tags » SSIS » Oracle (RSS)

NUMBER without Precision by MartinIsti

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...
Filed under: , ,

Oracle DATE vs SQL DATE by MartinIsti

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...
Powered by Community Server (Commercial Edition), by Telligent Systems