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 |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2010-11-11 : 05:31:18
|
| Ok I'm new to SSIS so please bear with me on this.I'm working on a package that my predecessor wrote and there is a step in it that fails if it tries to pick up a file of zero size.So my question is:-I want to check if the incoming file has at least one record in it before proceeding to the next step, and so I use sql something like :-SELECT COUNT(1) FROM incomingfile WHERE newdate > '01 MAR 2010'How would I use/control the output of this to fire up the next part of the process if the COUNT(1) produces > 0 ?I suppose it would be some sort of 'ON SUCCESS' routine but I am new to SSIS and don't know how myself.Thanks |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2010-11-11 : 09:27:53
|
| Sorted now thanks, used a row count component, a variable and an expression and constraint on the flow. |
 |
|
|
|
|
|
Help please!