If a file system fails to rename functions such as, for example if the file does not exist, then it is an error It is believed by SSIS that it fails in the entire package. I can get around this by using a script work, or by setting the maximum errors for the package for more than one. The problem of setting the maximum errors for more than one package is that if an error occurs then it will not fail if the package is somewhere else.
So is there any way to swallow anyway and still be able to branch on the basis of success or failure of file system work? I tried to successfully set up the file work in a sequence container, but this package still fails to say that the maximum error number has reached. I have participated in this exact problem and I have always used a script work, I do not think there is a better solution.
Comments
Post a Comment