Hello all!
I have an SSIS package that needs to read data from an .mdb file into sql, easy enough. Not all customers send the file as an .mdb initially, some are zipped. Even others send the .mdb with a datetime string appended to the file. So i have developed routines to take care of all these, but the package croaks as soon as it doesn't see the file name that will be used at run time. I have set delay validation on, but still no luck. Is there a way around this behavior?
Thanks