Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Silvm1
-
Scheduled DTS package always fails.
Ahh.. this sheds some light... Executed as user: *****. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSCreateProcessTask_1 DTSRun OnError: DTSStep_DTSCreateProcessTask_1, Error = -2147024891 (80070005) Error string: Access is denied. ****I removed the user...- Silvm1
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Scheduled DTS package always fails.
Hi, I am trying to schedule several DTS packages, 4 in total. One works perfectly. Three do not. The DTS packages run and successfully complete but when I either schedule the job, or manually kick off the job it immediately fails. I have tried this from remote and server locations. I am...- Silvm1
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
Non Roll - Up Measures
Great Thanks! Also, everytime I try to add a dimension to the cube from the fact it says, unable to count members of level. Is this because of the table size? Is there a way around this?- Silvm1
- Post #3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Non Roll - Up Measures
I have a fact table with about 70 mil records. I am trying to create a cube based on two measures. One should be summed across all dimensions and the other should be summed across all dimensions except time. It should always take the latest for the approriate time frame. I.E. If I am viewing...- Silvm1
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
