Archive for November, 2014

Check if you are minimal logging

November 11, 2014

A LOP_INSERT_ROWS will be present for every inserted record if you are not minimal logging

SELECT Operation,AllocUnitName FROM fn_dblog (DEFAULT, DEFAULT) WHERE Operation = ‘LOP_INSERT_ROWS’

Advertisements

Running SSIS package under different credentials

November 10, 2014

Create windows user name which will run your package
Create a sql login for the windows user giving it the relevant permissions
Create a credential for this login
Create a proxy that uses this credential
Update your job step to use the proxy