December 27, 2016 at 11:42 am
Hello,
I'm using a script task to check for file existence in a folder.
If the file found proceed with the data load, if not send an email to the users.
if the file is found then it proceeds to data flow task(Excel source, text file source) it works fine, but if the file is not present the excel source is failing saying VS is broken even though the script task doesn't need to go that path...
If I disable the data flow task and check, the package sends email without any issues.
December 28, 2016 at 2:28 am
How are you telling your package to not proceed the data flow task? I assume you're not using a task result of failure, so what are you doing instead? Does the email still send when it tries to do the process for a non existent file?
There are two ways you should be doing this. Either failing the script task using dts taskresult and then creating error handling for that failed task, Alternatively you can assign a value to a variable, and then put an expression in your flow, so that the next task is not run if the variable does not have the expected value.
What are you doing?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply