can dts (easily) combine several other db columns into another column on the same table? -- sql server dts

Ken Fine
11/30/2003 6:03:56 PM

Howdy, all. I'm interested in using DTS to automatically build indicies of
table content. What I'm imagining is with a table similar to the following:

tblArticles
_____

articleID (INT)
articleTitle (Varchar 50)
articleSummary (Varchar 200)
articleText (Text)
articleCombinedFields (Text)

In my scenario, the contents of the first four fields would be copied and
coalesced into the fifth, "articleCombinedFields".

(I would then build a SQL Server full text search index on
articleCombinedFields.)

Is DTS a good fit for this? I like the fact that DTS is easily scheduled,
and I suspect this shouldn't be too tough to do with the designer. What do
you think?

-KF

Allan Mitchell
12/1/2003 7:53:37 AM

DTS is no more easily scheduled than anything else in SQL Server. The Agent
handles things and that's that. It will be no easier in DTS than it would
be in a piece of TSQL.

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]

sql server dts : can dts (easily) combine several other db columns into another column on the same table?