we have a SSIS package (Created in SQL 2014 with DATA TOOLS VS 2013)
Dataflow task to load the excel sheet data to sql database
added precedence constraint for success to move the file to archive folder and rename to current data time (For each loop container -file system task)
added precedence constraint for failure to move the file to error folder (For each loop container - file system task)
It's working fine for success.
but for failure it is throwing below error at dataflow task and not going to next step on failure (moving file to error folder)
How to fix the precedence constraint editor to achieve this? i want to send the file to error folder for even DFT validation errors
TITLE: Package Validation Error
Package Validation Error
Error at Data Flow Task 1 [Source - Sheet1$ ]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37.
Error at Data Flow Task 1 [Source - Sheet1$ ]: Opening a rowset for "Sheet1$" failed. Check that the object exists in the database.
Error at Data Flow Task 1 [SSIS.Pipeline]: "Source - Sheet1$" failed validation and returned validation status "VS_ISBROKEN".
Error at Data Flow Task 1 [SSIS.Pipeline]: One or more component failed validation.
Error at Data Flow Task 1: There were errors during task validation.