April 15, 2015 at 11:09 am
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? For example, The package needs the file to be named collect.mdb. We get collect.zip, or collectDATETIME.mdb. The package will not run at all because collect.mdb isn't there at run time.
Thanks
April 16, 2015 at 2:21 am
Hi
I've got very similar scenario, users put the archive files on ftp with random names,
so Process Task launches a batch file which extracts file and renames as defined in connection string.
Br.
Mike
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply