Sure you can. You need to write a routine that checks for file existence and returns an appropriate return value which you can then check inside the transformer and proceed. I wrote a simple one months back. Search for it here.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
DSguru2B wrote:Sure you can. You need to write a routine that checks for file existence and returns an appropriate return value which you can then check inside the transformer and proceed. I wrote a simple one months back. Search for it here.
You sure you want to do that in a transformer? Once for every row processed by the job?
Use the 'Initial Value' area of a Stage Variable to do that if you only need to check once, then leverage that variable in the constraint for the job run.
-craig
"You can never have too many knives" -- Logan Nine Fingers