Hi

Thanks for your answer..based on ur query,i have written like this.

SELECT NON EMPTY { } ON COLUMNS,

NON EMPTY { ([PH_CUST].[CUST].ALLMEMBERS ) } ON ROWS

FROM Ad_CUBE

where except([PH_CUST].[Cust].Children,{[EMP].[PHWEB].[Activce].&[1]})

is it Correct...

Hi,

The Environemnt varibales that you are trying to Create(or) making any Changes made with SET will remain only for the duration of the current CMD session only...

try Checking this...

Hi Anthony,

In my case, I can't use the unpivot because.. the dates which i mentioned in column headers will vary at each and every point of time.. in this case.....

Hi Anthony,

Thanks for your help...i will try implementing the same..

Regards

Anil

I guess this might help you...Copy the Code in the script task and Change the Email's and SMTP Connection...

/*This code will take the latest file that was created in the...

hi

Change your query and specify the query hints like with (nolock ) on the destnation table..

Hope this helps

Thanks

AnilInampudi

Thanks for you reply Lowell,but i am not facing the same as you suggested.. the CDc job is not getting disabled i can agree with that. but, the job is...

Hey,

I guess in the script task under C# language add the script

string path = System.Windows.Forms.Application.StartupPath;

Dts.Variables["User::Root_path"].Value = path;

...

Hi Roy,

Thanks for your answer,

But based on the requirement,we are replicating the data from sql2005 to sql 2008.. while the replication is going on.. we tried implemeting the cdc...

Hey

Sorry dude, I am using Sqlserver 2005..y i posted in ss2k is..initilly i made a mistake posting the qury in SS2k..

Select Eligibility_Id, Subscriber_Id,span_num ,start_date,end_date,

(Select Eligibility_Id...

Hey Jeff,

Thanks for your help and time dude :-D, I tried from my end to solve the problem and Succeeded 100% ,but the only concern is that, it is...

Hey Wayne,

Any update on this..plzz help me out..:-)

Hey Mike,

Thanks for your assistance...this code is rearlly helpfull for fetching the depends objects with different schema as well... but in my sproc(stored procedure).i need to acesses the data from...

Hey Wayne

-- since you already have a clustered index, we need to dump the table to a temp table

-- where we can build the clustered index that we need for...

Hi Wayne,

Do i need to change some thing in this code..... this code is giving subscriber_id more than 112600, where as original sproc is not giving single subscriber_id.....

-- declare...