1

I have a ssis package which exports data from excel files and dump it into a SQL Table. For processing files, I am using a foreach loop and a dataflow opens an excel source and dumps data into ole db destination. If any file is not containing the required tab, I want the ssis package to log error and move to next iteration. I have tried following things but the package fails:

  1. Propagation = false
  2. ForceExecutionResult = Success

How can I handle this?

Attached images are the screen shots of control flow, data flow and progress.

Data Flow

Progress

Mehwish
  • 11
  • 1
  • 5

1 Answers1

0

Try on the For Each loop set maximum error count to 0 to ignore all errors.

In your for each loop have an on error sql script to write out if error so they are not lost.

Jim
  • 569
  • 6
  • 15
  • in addition to your other steps above that is, do them as well they're right as well – Jim Feb 13 '17 at 14:34
  • https://www.mssqltips.com/sqlservertip/3575/continue-a-foreach-loop-after-an-error-in-a-sql-server-integration-services-package/ this is a good guide should help – Jim Feb 13 '17 at 14:40