SQL Server 2000 EE

I am automating the process of looping, importing, and
archiving csv files that arrive daily (thanks to
www.sqldts.com/?246). The flat files (csv format
with "double quote" as text qualifier and no header) are
placed in a shared folder. The import process works fine
as long as the flat files are all csv with double quote
text qualifier and no header.

Unfortunately, the files have a header sometimes (albeit
rarely). The DTS imports the header as a separate row in
the table and wrecks havoc with my subsequent SQL scripts

To add fuel to the fire, they sometimes do not have a
double quote text qualifier.

I'm trying to make the users standardize their flat files
to a fixed format but unfortunately they don't always
listen and play by the rules.

Please pass on ideas to resolve these issues. Also, ideas
on improving this whole process of frequently importing
flat files into SQL are appreciated.

Thanks,
Vinod.

For your header problem you could filter this in your script as well from
the article you are using. Simply check for a header and you can then set
the properties of the text file so that you skip n rows. (not tried)



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


"Vinod" <anonymous (AT) discussions (DOT) microsoft.com> wrote