Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2010-06-16 : 08:26:07
|
| i have an ssism in which i have in the first step a task which checks if file exist, if yes return success, if not return failure, so i wll know if to go ot the second step,the problem is, when i dont have a file at step 1, and i watch the job history i see it as an "error" (and this is not really an error, beacuse in the fist place i wanted to stop from going to step2 if there is no file).how can i change this?Thankspeleg |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-06-16 : 08:47:23
|
In a similar case I have done a select count(*) from ...Then I have assigned that value to a package variable.Then per double click on the workflow arrow I have made an Evaluation operation on @[User::Countervar] to decide if the package can go to next task.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
exit an ssis package with no error