How to update the source table in the same job?

kduke · Post by **kduke** » Tue Mar 06, 2007 6:33 am

On the source SQL. It should be an option. Read help on the choices. You will understand why.

dohertys · Post by **dohertys** » Fri Dec 28, 2007 4:31 am

Does this (setting ur) have to be done as 'user defined' sql then - or can it be done on any of the other 'Read methods'?

Or should you 'set change isolation to ur' as an 'Open Command' (would that work?)

kduke · Post by **kduke** » Sun Dec 30, 2007 1:36 pm

Depends on your source database and stage chosen. In SQL Server you could do a (NOLOCK) with User Defined. Some stage types have this in the options. Even though you may need a no lock as well as the option.