*sigh* I'm losing the plot here. :crying:

Snapshot isolation cannot be used within distributed queries.

http://msdn2.microsoft.com/en-us/library/ms188277.aspx

"For most applications, read committed isolation using row versioning is recommended over snapshot isolation for the following reasons:

* It consumes less tempdb space than snapshot isolation.

* It works with distributed transactions, whereas snapshot isolation does not.

* It works with most existing applications without requiring any change. Applications written using the default isolation level, read committed, can be dynamically tuned. The behavior of read committed, whether to use row versioning or not, is determined by the database option setting, and this can be changed without affecting the application."

Seeing as how what we want is to run a SSIS package within a single snapshot transaction and SSIS uses the MSDTC to manage transactions but snapshot isolation is not supported in distributed queries... does that logic flow?

If something does not support distributed queries does that mean it does not support distributed transactions?