Viewing 15 posts - 241 through 255 (of 270 total)
Have you tried putting the code for updating the recordset in your main function and running that? In other words, not use a second function at all? If it works...
August 9, 2002 at 9:19 pm
I would try installing SP2 on both Analysis Services and SQL Server...you can download these from the Microsoft SQL Server site...
hth,
Michael Weiss
August 6, 2002 at 5:40 pm
Just out of curiosity, what service pack are you running on SQL Server and Analysis Services (they are separate service pack exe's)?
Michael Weiss
August 5, 2002 at 2:32 pm
Are the permissions that SQLServerAgent the same as the user logged in when you execute the package directly from within DTS?
hth,
Michael
Michael Weiss
August 5, 2002 at 2:28 pm
Your assumptions (1) & (2) are correct...use an activex task, with ADO query for your max value...then you should either be able to use a global variable in your insert...
August 1, 2002 at 12:00 pm
Have you tried using either an activex task object or a dynamic task object along with a global variable to pull the max trans number from the destination table then...
August 1, 2002 at 8:48 am
Sorry! Please ignore my earlier response...I went back and re-read your question and realize that you were not asking about DTS Diagrams, but using DTS to move a database diagram...my...
August 1, 2002 at 8:42 am
If I understand your question correctly you want to move one or more DTS diagrams from one database to another within the same sql server. DTS Diagrams reside on the...
August 1, 2002 at 8:40 am
Do you have your analysis services tasks set to run on the main thread? They are written in vb and vb is not multi-threaded. Right click on the OLAP task...
July 30, 2002 at 9:17 am
Hi
Excel automatically aligns number values (or values it perceives to be numerical) to the right. All values perceived to be text (such as your alphanumeric values) are automatically left aligned...
July 25, 2002 at 3:19 pm
The analysis services process cube task is written in vb. VB is not multi-threaded therefore you have to make sure that the tasks in your package are set to execute...
July 19, 2002 at 1:12 pm
I was finally able to get it working! I tried re-registering the dll's but that didn't work, re-installed AS but that didn't work either, finally ended up deleting the cube...
July 18, 2002 at 9:22 pm
It just keeps getting more interesting...if I click on the cube in Analysis Services and select Process, I get the 'Object Variable or With Block Variable Not Set' message...any ideas...
July 18, 2002 at 12:13 pm
Okay...the plot thickens! I attempted to process the cube in Analysis Services Manager. I first wanted to see if I could open it for editing...when I attempt that I get...
July 18, 2002 at 11:03 am
In 'Microsoft SQL Server 2000 DTS' by Timothy Peterson, pg. 414, he states that you can not do an incremental update on multiple objects. I haven't been able to check...
July 17, 2002 at 7:42 pm
Viewing 15 posts - 241 through 255 (of 270 total)