I found the problem. When evaluating @FirstPerYrAnnum = DATEADD(YEAR,-1,GETDATE())), The variable @FirstPerYrAnnum contained only the YEAR portion of the date. I needed to express my test as follows;

@FirstPerYrAnnum = YEAR(DATEADD(YEAR,-1,GETDATE()))

Now...

Bingo! Thanks a million!

CSDunn

Thanks again. No, those are not the correct results.

The following is the result set from the inital posting;

DaAcctCode CYJanRev PYJanRev

AM940         2.25         0.00

AM940         2.25         12.75

AM940         2.25         745.00

AM940         2.25         1620.50

AM940         511.00      0.00

AM940         511.00      12.75

AM940         511.00     ...

Thank you for your input. I want to get an accurate total for both of the Revenue fields in one result set. The code you have posted correctly represents the...

Thanks again!

CSDunn

Thank you for your help!

CSDunn

I did actually find a handy utility that is supposed to work with a batch file to do the burning. I haven't had time to look into it yet, but...

Thanks for your input. I was actually able to do this with a Conditional Split Transformation.

cdun2

Here is some input that I recieved from one of the MSDN forums today;

**************************

The error from the destination is causing the whole dataflow to fail.

one can shunt failed rows...

I haven't tried it yet, but this might work;

[Column 0] == "D1" &&( [Column 44] !="D" &&[Column 45] !="1")