it does not work any suggestions

still not cleared .is there anybody who can guide me on this

i dont have sample data but if you see the proc on all the four level where iam doing the rollup i am getting duplicate.

is there any guru available to help me

thanks for the help

can you modify the package ? and change the transformations

Just a quick question aftere the wizard biulds the package how can i analyze it what it does so i can biuld a similar package as per my requirements

My question is like what are the other options beside using import-export wizard-what are the steps needed to create a package.

Thanks for the help but  can you tell me one more thing in this proc.

what i want to do is to sum the Uniformat_Cost in the COST_PROJECT_PHASE_UNIFORMAT table and then...

It gives me an error message when i execute it.

Msg 207, Level 16, State 1, Procedure COSTUpdateProjectPhaseHeader, Line 17

Invalid column name 'COST_Project_Phase_Uniformat'.

CREATE PROCEDURE PR_YOURPROCNAME(=@MS_ID INT,=@PROJECT_ID  INT) AS

UPDATE...

The error shown refers to my case statement where i am using the column name 'Level1' and 'Lvl2' .The thing i dont understand which column name should i use.follwing is...

thanks for the help

Thanks for the help

i have a table A which has column name as FlagID with datatype bit

i want to update the whole column with a value 1

can somebody help on this please