Hi,

Thanks for the reply.

we have total 350 rdls

Hi u r almost cortrect.

Every week i will have to add one row and i will have to maintain a flag with column name Currentweek and this column is Y...

Thanks

Yeah I got the solution

I got an "official' exchange rate source from client.

Thanks for u r response..

Thank u so much

I did according to your guidance ..

It was giving the error like this:

The data type of the variable(here my sql variable was in object data type ) was not supported...

Hi friends

I am totally new for SSIS

I need to extract the data from the Three tables and insert into one table based on the conditions.

Is there any way that...

I want to have a user be able to launch a DTS package that I've written. Their client machine (whether it's a local workstation or the Citrix box) doesn't and...

I have 3 tables named Business_segment_Data,OneWeekData and DimTime.

update Business_Segment_Data

set Business_Segment_Data.lastweekdatedata = b.amount

from oneweekdata a,oneweekdata b,DimTime c,Business_Segment_Data

where a.branch_alt_key = b.branch_alt_key

and a.schemecode = b.schemecode

and a.weekdate = dateadd(week,1,b.weekdate)

and dateadd(week,1,b.weekdate) = c.pkdate

and Business_Segment_Data.timekey...