SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
Data Flow Cannot Support Error Redirection When Used in a Transaction Error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 10%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
libpekin
86
Reputation points
Hello,
I'm attempting to leverage the built-in Transaction functionality but to no avail. I followed the MSFT Learn docs and enabled MSDTC on the database server (same server SSIS is running on).
Find below my test package configuration and error message. The message is saying that the data flow task cannot be set to redirect errors when using a connection in a transaction.
Is this a knows SSIS limitation? Is there a workaround for requirements that need to leverage SSIS Transactions? Thank you!