Data Flow Cannot Support Error Redirection When Used in a Transaction Error

libpekin 86 Reputation points
2024-06-26T17:57:05.28+00:00

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).

https://learn.microsoft.com/en-us/previous-versions/commerce-server/dd327979(v=cs.95)?redirectedfrom=MSDN

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!

User's image

User's image

User's image

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
0 comments No comments
{count} votes