Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Automation

  
   Database Help (Home) -> Datamining RSS
Next:  Using IIF in a Stored Procedure linked to a Repor..  
Author Message
Utf-8Bc2FvbW90MjAw

External


Since: Apr 21, 2004
Posts: 5



(Msg. 1) Posted: Tue May 25, 2004 11:11 am
Post subject: Automation
Archived from groups: microsoft>public>sqlserver>datamining (more info?)
How do I automate the following since I have to fetch my data from a remote database:
1. Cube generation;
2. Dimension generation;
3. Model generation; and
4. Tie steps 1-3 together into a procedure that can run periodically.

Your early and resourceful response will be appreciated. Thanks.

 >> Stay informed about: Automation 
Back to top
Login to vote
Peter Kim MS

External


Since: Sep 04, 2003
Posts: 88



(Msg. 2) Posted: Tue May 25, 2004 1:36 pm
Post subject: Re: Automation [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Have you looked at SQL Server DTS?

--
Peter Kim
This posting is provided "AS IS" with no warranties, and confers no rights.

"saomot2000" <saomot2000.RemoveThis@yahoo.com> wrote in message
news:BF39FA7A-63DC-4CE0-AE19-15099DFD58AE@microsoft.com...
 > How do I automate the following since I have to fetch my data from a
 > remote database:
 > 1. Cube generation;
 > 2. Dimension generation;
 > 3. Model generation; and
 > 4. Tie steps 1-3 together into a procedure that can run periodically.
 >
 > Your early and resourceful response will be appreciated. Thanks.<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Automation 
Back to top
Login to vote
Eric.Li

External


Since: May 28, 2004
Posts: 15



(Msg. 3) Posted: Fri May 28, 2004 7:12 pm
Post subject: Re: Automation [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
What do you mean generation? Refresh data? If that's the case, DTS is
the way to go.

--
Eric Li
SQL DBA
MCDBA

saomot2000 wrote:

 > How do I automate the following since I have to fetch my data from a remote database:
 > 1. Cube generation;
 > 2. Dimension generation;
 > 3. Model generation; and
 > 4. Tie steps 1-3 together into a procedure that can run periodically.
 >
 > Your early and resourceful response will be appreciated. Thanks.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Automation 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Collation Problem any help - Hello all : My problem is like the following I have an online databse with a latin collation, this database is using ntext and nvarchar values that was with our previous admin ok the problem is in the data is stored should use another collation (the...

Reprocessing a mining model - I'm currently developing a user registration prototype. The aim is to classify certain types of users. However, after the registration I query a decision tree model in Analysis Services with DMX and I want to send the user data into the warehouse to....

Trying to cut down query times - I have a query that is based on two other queries that are based on tables in a database. All of the queries that are used for this final query use grouping and totals. In the application I am making, I need to choose a date range to select the subset....

Update serial number in database - Hi, I want to update specific fields in a existing table in SQL database as below example: L240100001-LG L240100002-LG *serial number is difficult to update one by one L240100003-LG L240100004-LG L240100005-LG change to L240100001-L L240100002-L..

Newbie question - I have SQL Server 2000. What add-ons do I need to try data mining, and where do I best go for resources/references?
   Database Help (Home) -> Datamining All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]