I'm looking for an example of a very straightforward DTS
implementation: parse a text file that has names, address, and phone
nmbers in it. Normalize the data by putting the names in the 'people'
table (if not already there), and updating the address in the
'address' table, and the phone number in the 'phone' table. I guess
what I am really looking for is an example of how to use the DDQ task
to do normalized inserts and updates across multiple tables.

Does anyone have an example of such a package, or can point me in the
right direction to learn the proper way to learn how to do this? I've
been getting the data in via the ADO interface, stored procedures, and
visual basic code, but now I think it is time to make the jump to DTS.

Thanks!
Joe

You could of course use lookups.

How to Use Lookups in DTS
(http://www.sqldts.com/default.aspx?277)


A DDQ for your situation is not really what I think you want. A DDQ IMHO is
to be able to respond to events that you flag i.e. UPDATE, INSERT, DELETE.
Although you can use them in other ways.

With lookups you would run over the data extract the necessary attribute
info. You would then pass it to a Stored Proc perhaps and it would do the
insert or update.



--
--

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

"Joe" <jjo_chicago (AT) yahoo (DOT) com> wrote