Hello,

How are you today?

I wish to carry out the following:

1. Periodocally Import data from a csv file into a temp table.
2. Clean the data (which mainly would involve identifying values not
present in a lookup table and cleaning Postal Code info.)
3. Report any errors found so these can be fixed
4. Append the clean data to the destination table.

Since my destination table will be in SQL Server I wish to use DTS,
but was wondering if they are any good tutorials which I can use as a
guideline or alternatively if scripts exist to achieve this goal.

Your methodology is one that I would use also. I always import text/csv
files into working tables. I then use TSQL/VBScript to scrub my data.

3. I presume by errors you mean duplicates. Easily done simply by matching
on key columns
4. Easily done by matching on key columns (Outer Join) where the real
table's key column is blank.

--


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