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)

SQL Server Blogs