Skip to main content
12 votes
Accepted

Is "ROW_NUMBER() OVER(ORDER BY xml.node)" well defined?

No, it's not documented and therefore not guaranteed. In practice, it probably is guaranteed as I described in a Stack Overflow answer (reproduced below) but that doesn't meet your stated desire for ...
Paul White's user avatar
  • 86.9k
1 vote
Accepted

.DTSX package is there a way to wrap a workflow into a transaction

You can read about SSIS transactions here. Configure a package to use a single transaction In this option, the package itself initiates a single transaction. You configure the package to initiate ...
David Browne - Microsoft's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible