Flat File Source Editor

Question

Flat File Source Editor

react 92671

SSC Enthusiast

Points: 136
More actions
March 16, 2010 at 4:20 am

#138640

Hi all!
I'd like to know if it is possible through SSIS to avoid errors when a flat file does not exist and the package tries to load it.
I did not find anything about this topic..must I first search the file through script and then load the file or is there a more suitable solution?
Thanks!

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246959 More actions · Answer 1

If you know that the file will exist at run time and you're just avoiding design-time validation errors, set DelayValidation = True.

If you want a package to run successfully regardless of whether the source file is present, put your dataflow inside a foreach loop container.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

react 92671 SSC Enthusiast Points: 136 More actions · Answer 2

Thanks for your reply. I want to avoid problems in case the file is not there.

But the for each solution is not applicable, since there are many files and their load must be sequential...

Phil Parkin SSC Guru Points: 246959 More actions · Answer 3

OK - what do you want to happen if some of the files are present and some are not? Import them, or not import anything?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

react 92671 SSC Enthusiast Points: 136 More actions · Answer 4

I want the flat file source component to be skipped if the file is not there 🙂

is it possible?

Phil Parkin SSC Guru Points: 246959 More actions · Answer 5

So I am assuming that you have multiple dataflows, connected in some logical order. You want each of the dataflows to finish successfully if the source file is not found, continuing to the next.

I am thinking that a combination of scripting, setting appropriate variables and using precedence constraints would be the way to go. There's no simple setting to achieve this, unfortunately - would be useful.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

react 92671 SSC Enthusiast Points: 136 More actions · Answer 6

react 92671

SSC Enthusiast

Points: 136

March 16, 2010 at 5:01 am

#1134327

Ok, that's what I wanted to know!

thanks!