You cannot simply rollback a named nested transaction you can only rollback to a savepoint.

"Naming multiple transactions in a series of nested transactions with a transaction name has little effect...

Yes, it seems inconsistent that '-' will convert to int but not float. This comes out another way with the order of evaluation:

select 6 + '-' + 1.0;

select 6.0 +...

I have dual core and 4GB. When I get the chance I'll try using a remote SQL Server that should help.

Interesting stuff but I tried adding "waitfor delay '00:00:01';" to each of the sample work SQL tasks in the OnePackageMethod (before the update statement). That way you can see what...

There may be other motives for the method shown that I'm not getting but it seems to be an insanely inefficient and complicated way to do it: read service, write...

It's also interesting that coalesce behaves a different way from isnull.

My point in giving the isnull/convert formulation was to show how to make isnull behave in the way you might...