dbTalk Databases Forums  

Questions about using DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Questions about using DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Vicky
 
Posts: n/a

Default Questions about using DTS - 05-16-2004 , 10:21 PM






Dear all

I want to use DTS for data mining. However, I am just a beginner of this tool. I am not sure whether DTS can help me to
stabilize variance, remove nonlinearity, improve additivity, correct nonnormality and transform an interval variable (for example, age) into a group variable. If DTS can do so, then how to do? Can somebody help me

I found that many people use ActiveX script to manipulate DTS in the newsgroup, so do I have to learn some programming language (for example, Java Script, VB and XML) for using DTS? Does DTS have an interface to let user choose the options instead of writing programming lanuage

Thanks for helping me

Best Wishes
Vicky

Reply With Quote
  #2  
Old   
Michael Vardinghus
 
Posts: n/a

Default Re: Questions about using DTS - 05-17-2004 , 05:46 AM






Hi Vicky

See you found the DTS-newsgroup.

I'm not a data mining expert (more datawarehouse / olap) but you cannot say
that you can use DTS for data mining - you can say that you can use DTS for
preparing an SQL Relational environment that can be used for data mining
(perhaps using Analysis Services...)

Whether AS data mining facilities are enough to support your requirements I
don't know.

DTS is primarily used for doing something using SQL (and other task types)
so the data can be used in a mining model - but the mining model needs to be
defined in AS - at least I think so....related to cleansing data using DTS
there is no limits to what can be done but you need to know what relational
structure is needed for youre requirements.

\Michael Vardinghus

"Vicky" <anonymous (AT) discussions (DOT) microsoft.com> skrev i en meddelelse
news:0039E604-4871-49F6-980A-FFE3AA2BB9BB (AT) microsoft (DOT) com...
Quote:
Dear all,

I want to use DTS for data mining. However, I am just a beginner of this
tool. I am not sure whether DTS can help me to
stabilize variance, remove nonlinearity, improve additivity, correct
nonnormality and transform an interval variable (for example, age) into a
group variable. If DTS can do so, then how to do? Can somebody help me?
Quote:
I found that many people use ActiveX script to manipulate DTS in the
newsgroup, so do I have to learn some programming language (for example,
Java Script, VB and XML) for using DTS? Does DTS have an interface to let
user choose the options instead of writing programming lanuage?
Quote:
Thanks for helping me!

Best Wishes,
Vicky



Reply With Quote
  #3  
Old   
Vicky
 
Posts: n/a

Default Re: Questions about using DTS - 05-17-2004 , 08:46 PM



Thanks a lot! Micheal...^_^

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.