Viewing 15 posts - 211 through 225 (of 270 total)
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...
September 11, 2002 at 3:05 pm
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...
September 10, 2002 at 2:18 pm
also the SQLAgentCmdExec user may need to be a member of the sysadmin group on your sql server...
Michael Weiss
September 9, 2002 at 4:08 pm
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...
September 6, 2002 at 11:28 pm
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
September 4, 2002 at 7:42 pm
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...
September 4, 2002 at 7:15 pm
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...
September 4, 2002 at 10:11 am
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...
September 4, 2002 at 9:26 am
Have you come across an answer to this yet? I would be very interested if you have...
Michael
Michael Weiss
September 1, 2002 at 6:02 pm
Thank you! I reapplied SP2 to both the SQL Server and Analysis Services...this seemed to solve the problem.
Michael Weiss
September 1, 2002 at 5:54 pm
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...
August 28, 2002 at 6:05 pm
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'...
August 24, 2002 at 2:24 pm
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...
August 23, 2002 at 6:47 pm
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...
August 23, 2002 at 2:11 pm
Does the user account your SQL Agent is running under have permission to access the share?
Michael Weiss
August 21, 2002 at 9:42 am
Viewing 15 posts - 211 through 225 (of 270 total)