I have an import text file whose definition might vary.

Is it possible to create an ActiveX script task that will check the field
names in the text file before importing to ensure they are the same as the
destination table field names?

For example, the script should test to see if the 3rd field in the text file
is named "city" before importing the field contents into the "city" field of
the destination table.

You will have to write your own validation/scrubbing program. You would
read line#1 of the text file and count the delimiters so you knew when you
were at col 3. You can then test the value there.

You could easily do this in an Active Script task.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


"Dave" <dave (AT) nodomain (DOT) tv> wrote