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 |
|
Trudye
Posting Yak Master
169 Posts |
 Posted - 2009-02-25 : 09:10:15
|
| I need a qry that will give me a negative/failure result when there are not records in a table. I can’t get my pkg to fail and exec my Failure Constraint, here is what I wrote. select count(Orig) as NoAG from Import_2Where Orig In ('A', 'G')Any ideas how I can get this puppy to fail?Thank much,Trudye |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-25 : 09:16:56
|
do you meant this?select case when count(Orig) >0 then 1 else 0 end as NoAG from Import_2Where Orig In ('A', 'G') |
 |
|
|
Trudye
Posting Yak Master
169 Posts |
Posted - 2009-02-25 : 11:07:01
|
| Ooops! I just realized I should be in the SSIS forum, thanks anyway guys for the feedback,Trudye |
|
|
|
|
|
|
Constraint Failure