you try for fast load option in the destination editor...It should help u out...

I think you won't get any results in SSMS....u ll get only the package is successful or not...you can enable logging if you want to know these details...

yeah ...I did nt have proper cube design....I got it now...Thanks a lot ....

okay....I got it...Thanks a lot...

oh gr8....Thank you very much.....and can we use that cd multiple times or only for one time installation?? and does it have any expiry date like 1 year??

okay... In that case the users need to connect to the remote server using remote desktop connection (they should be on the same network). then they can run the ssis...

I don't think we can run an ssis package with out the installation of sql server and ssis on local or remote...

can you tell what error message do u see there??

Thanks Rob...may be I ll go for date checking in my SSIS package...it should work...

I don't find any reason...but my boss is wants only through task scheduler....

we have 12 views for every month...we copied all the data into the single table and made it data for 1 year....so we have only 1 table now...

Thanks for the replies.....actually that query access the view which is formed by the unions....so we can't index the view with unions...so we changed our plan and built the new...

Thanks for the advise...thats a good idea...I m looking for all the ways I can do...I will try this...

Thank you rbarryyoung ....I m sorry for the inconvenience...next time I will follow that...

Thank you very much Carl Federal...Let me try that...