Link to home
Create AccountLog in
Avatar of George Contrabass
George ContrabassFlag for United States of America

asked on

If source files missing, how to end entire package.

Using VS 2019 / SSIS

I need to import 4 or 5 files for each day.

There may be days with no data.

Each file will have a date embedded in its name.

Files prefixed with E are optional.

There can be multiple days' data.

For example

A010123.txt, B010123.txt, C010123.txt, D010123.txt, E010123.txt,

A010223.txt, B010223.txt, C010223.txt, D010223.txt,

A010323.txt, B010323.txt, C010323.txt, D010323.txt, E010323.txt.

A010423.txt, B010423.txt,                          D010423.txt, E010423.txt.

If this was simple, I'd just have 5 for-each file loops and call it done.

However ...

In the example above, all files for 1/1/23 - 1/3/23 would be processed..However - i don't want to process any of the files for 1/4/23 until I get a chance to hound the client for the missing C file.

Would this have to be accomplished by using a script?

If so, how does one "fail" or end the flow from there?

Avatar of waynezhu

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account