I'd like to know if it is possible to do very limited normalization tasks
using the DTS designer.

I've inherited a table:

tblGarbage
-------
field1
field2
field3

I want to map this into my relational database :

tblPersons
------------
Per_PersonID
Per_GivenName
.....

tblPersons_PersonsCategories
-------------------
Per_PersonID
PerCatID

For each row in tblGarbage, I want to map fields into tblPersons, copy the
just-created Per_PersonID to tblPersons_PersonsCategories, and enter a
hardcoded value, say, "2", to PerCatID.

I know how I could script this using something like ASP. Is it possible to
do this sort of simple task with the DTS designer?

Thanks in advance.

-KF

Heh. Sorry about the funky account/user name on that post.

-KF


"msnews.microsoft.com" <kenfine@u.washington.edu> wrote

It certainly is possible.

You can use Lookups or you could, as I would do, run over your data twice

Run 1: Insert into the tblpersons entity.
Run2: Insert into the tblPersons_PersonsCategories entity by joining your
Garbage entity onto the tblpersons entity and retrieving the attribute
values you require.



--
--

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


"msnews.microsoft.com" <kenfine@u.washington.edu> wrote