Good Day All,

I have successfully managed to write load packages for data from
another source into SQL via DTS.

I have one 'master' table which needs the following type of
transformation though - and being very green, I am struggling to
figure out how to accomplish this through DTS:

Example: The original data source keeps say, the actual
DepartmentName as a value in it's 'master' table, I have split this in
my design (obviously) - so I need the incoming DepartmentName to be
checked against my Departments table and the DepartmentID for it to be
inserted into the 'master' table instead of the name (i.e. thus
creating my foreign key instead).

Can this be done in one foul swoop?! Please say yes . There are a
few "lookups" like this for my 'master' table.

Thank you in advance
Regards,
EvE
PS: If there are good sources for DTS related functionality that I
can have a look at, please throw them my way - I am quite willing to
figure it out myself with a teeny bit of guidance!

www.SQLDTS.com is a pretty good resource if I do say so myself.

Yes you can do it. Have a look at Lookups.

You may need to make > 1 pass but this is not a bad thing

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"EvE" <eve_calypso (AT) yahoo (DOT) com> wrote