"EvE" <eve_calypso@yahoo.com> wrote in message
news:491d3029.0410210131.307a8e04@posting.google.com...
> 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!