Run the package – it works.
Alter the source table
ALTER TABLE dbo.TestTable DROP COLUMN ExistingCol;
Run the package again – you’ll see:
Error 0xC0049015 at Derived Column [2]: The component "Derived Column" (2) failed validation because the required column "ExistingCol" could not be found in the input.
That is SSIS‑913 in action.
If you want, I can:
While troubleshooting is essential, adopting best practices can help minimize the occurrence of the SSIS-913 error: SSIS-913
The SSIS-913 error is a specific error code that users may encounter while working with SSIS. This error can manifest in various scenarios, including during package execution, design time, or when deploying SSIS packages. The error message associated with SSIS-913 can be cryptic, often leading to confusion about its root cause. Run the package – it works