Data Flow Cannot Support Error Redirection When Used in a Transaction Error
libpekin
166
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!
Sign in to answer