SSIS

Solving the ROW-00060 Error When Using SSIS with Oracle

by
SSIS logo

I have built SSIS packages to load data from one Oracle database to another before, but never had I come across this error until recently: “ROW-00060: Internal error: [dainsert,16] Source: Oracle Destination: Oracle Error Occurred @ after 403k records.” Initially, I thought that some constraint had been violated on the destination data source – like … Read more

Quick Fixes on SSIS with Oracle Data Sources

by
SSIS logo

I’m currently in the process of building out an ODS (Operational Data Store) that will integrate data from multiple systems and make that data available for reporting using Spotfire and other BI tools. Both the ODS DBMS and the first system that will be used as a source for the data in the ODS run … Read more