What do you mean by SQL web user? The user logs on to your web site with their sql server or nt user credentials? Is anonymous access disabled in IIS?...

Check the permissions on the folder which contains the files you are deleting. Make sure the account that the job is running under has authority to access and modify the...

It certainly could. I am having problems with a cube processing task in a DTS package and am thinking it is a permissions issue as well. Have you checked the...

You could try reinstalling MDAC on the server in question...maybe v2.7? Just a guess...

hth,

Michael

Michael Weiss

Okay...the ongoing saga...well, the package completed without error last night. I also had the trace running and the cube processing was definitely accessing the data store. Still, though, the filter...

Steve,

Did any of your searches produce results suggesting to re-install AS? All of mine have...well, either re-install AS or re-install the latest SP for AS. Interestingly, when I ran the...

Hey Steve,

No, I didn't do any tracing but that is a damn fine idea...I will run that tonight. I reinstalled SP3 for AS and for SQL Server. Then I ran...

Been there and done that too..lol! The package failed last night with the error:

Step Error Source: Microsoft Data Transformation Services (DTS) Package

Step Error Description:Invalid clipboard format

(Switch Management (80004005): Partition 'Switch...

Thank you...that option was always checked. This really has me puzzled...now it seems that the cube processing never completes no matter how long I let it run. I am going...

Thank you, Steve. I will have a look at the documents. I am really thinking this has something to do with all of the Win2k updates that were installed on...

As a follow up, I noticed that after stopping and restarting the AS service, total memory usage on the server drops by approximately 2gb. Also, the msmdvldm.exe service starts two...

Hey, Mark...it's all just zeroes and ones...how hard can it be? 🙂

Seriously, to answer your questions 1)search under 'cube processing' in BOL and 2) get a copy of Microsoft(r) SQL...

PS - check in BOL for refreshing a cube vrs processing...

Michael

Michael Weiss

You could set the source table filter in your cube to exclude those records where the flag field = 1 (or whatever your flag is). Then you should be able...

I think that the F3, F4, etc are column names assigned when there are no specific column names in the Excel spreadsheet. Have you tried giving your spreadsheet columns names...