SQL Server

SQL Server Script to Create INSERT Statements

by
Microsoft SQL Server logo

Though you can generate INSERT statements using SQL Server Management Services if the Generate Scripts functionality is enabled, this script may help in cases when it is not. This script may not work in every single case, as there are data types not accounted for here.

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