Jason but the problem here is if i have two rows such asa

col0 col1 col2 col3 col4 col5

1 0 ...

SELECT

km_ndc

,CASE WHEN SUM(extended_amount_corrected)

+ SUM(qty_corrected)

...

Thkz Jason ... I need not group the last 4 Columns actually but if i dont do that it throws me an error so i have jus added it ....what...

here is my query... small change in the query

select km_ndc,

case when (extended_amount_corrected)=0.00 and

qty_corrected = 0 and

cost_corrected = 0 and

contract_price_corrected = 0 then sum(extended_amount_submitted )

else sum(extended_amount_corrected)

end

from...

gotch u Micheal...thkz

But in the expression we have =="" but null doesnt mean zero length string also ...so do we get the results we need according to his req because he needs...

Thanks Michael. I believe i should go through the Basics ....Bcoz i never know that isnull is diff from t-sql anyway i tried searching through google and got a...

Without seeing the error or the package, it is hard to tell.

You probably have a data type issue though.

If SchemeID is a string:

ISNULL(SchemeID) || SchemeID==""

Also - be sure...

hi ..as micheal said u can do it throught conditional split ...

from the excel source give it to conditional split once all transformations are done then in the expression give...

What is the equivalent of

Tables right click -> Export Data in SQL Server 2000 Enterprise Mngr in SSIS?

u vl have that in ssms i mean management studio...

what did you set in the result set property none or anything else ???

plzzzz ..my mail id is Kurraraghu@gmail.com

thkz lookup i gotch u now....i found it ..could u recomend me some sites for scripting plzzz

sorry i said component in the last post srry it is script task

yeah till now i was looking in the script task so i was a bit confused ....I have...

yeah till now i was looking in the script component so i was a bit confused ....I have attched a screenshot so please let me know if that is the...