title: how to prevent SSIS package failure when no file(s) exist to import
body: <p>I have an SSIS package with several data flow tasks.  Each one imports a flat file into a table in my DB.  I have created a connection manager for each underlying flat file.  The package works just fine if all of the files exist.  However, even if one of the files is missing, the entire package fails.  I don't want this behavior.  For whatever files that exist, I want my package to import them.  For those that don't exist, I want SSIS to simply ignore them.  At least one of the files will always exist.  How do I achieve this behavior?  I have seen some solutions that involve either scripts or file control tasks, but I'm not sure which is appropriate for my situation.</p>