I don't know if it is a permissions issue or not but you might check user permissions. You can always save your package as a structured storage file and then...

I would recommend looking at user permissions that DTS is running under on your production environment versus those of your development environment. Also, are both instances of SQL Server the...

also the SQLAgentCmdExec user may need to be a member of the sysadmin group on your sql server...

Michael Weiss

If you have access to Analysis Services, there is a tutorial in the Analysis Services Manager. One of the best books available is Step by Step Microsoft SQL Server 2000...

I hear you. I am getting to the point where I am almost afraid to do anything with AS...and documentation is virtually non-existent!

Michael Weiss

If you are running any Analysis Services apps on the same server, you may want to upgrade to MDAC 2.6 and not MDAC 2.7...2.7 overwrites the OLEDB OLAP drivers but...

I was concerned that AS would try to do a self-join...the data I am working with does not lend itself at all to a normal star schema as it contains...

Is it possible that DTS packages are cached somewhere? The behavior you experienced is disconcerting to say the least. Yesterday I had a somewhat similar experience in a DTS package...all...

Have you come across an answer to this yet? I would be very interested if you have...

Michael

Michael Weiss

Thank you! I reapplied SP2 to both the SQL Server and Analysis Services...this seemed to solve the problem.

Michael Weiss

You want to specify a destination file dynamically? You could also look into the dynamic properties task...with that you can set a global variable dynamically and set your transformation task...

So I start a refresh data operation on the cube and I get the following error:

Analysis Services Error: Processing Error [Attempt to delete member that is in use]'0000000000'

...where the '0000000000'...

FYI - I found out that when a cube is processed, Analysis Services sometimes sets the visible property of the cube to false. This triggers the error as well since...

Have you checked the permissions of the user account that SQLServerAgent is running under? Seems like a lot of these issues are centered around proper access permissions of the service...

Does the user account your SQL Agent is running under have permission to access the share?

Michael Weiss