Hey Stev ,
I will check  OupPut of the query with the result set and get back to you.
Thanks
VD

All the points you mentioned are set.I am using Tablix and the column is having a very big text (Even bigger  not fit in single page),  this instead of starting...

Any Help HERE ?????

I tried to keep the transactions on separate piece but business rule does not allowing me to do. I can only have single Transaction. Equally I can not perform this...

Hey Matt,

BEGIN TRY  
  BEGIN TRANSACTION          SQL1      COMMIT
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
   ROLLBACK
END CATCH
Will...

Initially  I though to preform  direct INSERT but , Yes got the point pull the Data Using SSIS. That way i can perform Multiple jobs at a time to boost...

Hey Frederico ,  

Much thanks to guide me on this..Now  I am performing  trial at one of the server. but i have an issue as i have very...

Also do take care of the SystemdB (Master,Model,MSDB) for Users and the jobs if any

Yes , we have sufficient space to occupy the replica of full copy of the table.
Yes , the existing records may update. 
I have few queries related to the...

Thanks for being so nice.. i was just downgrade my Enterprise Version Cube to SE Edition ...

Cube processes successfully

1- set semi-additive Aggregation function Sum/Count

2- Created Calculated Members using Standard...

Thanks a lot. Is it a SSRS limitation I guess. What do you suggest the color code for the

below opacity level for the Standard Black color. As i come...

Nice question,

But Not having much information on MSDN for 'NULL' behaviour and incorrect value pass to the constraint.

!!!!!CAN I GET ANY HELP???!!!!!!