Hi,

Can anyone tell me what the best way to automatically download a .dat
file from an ftp site and import into sql server?
Should I use ftp.exe? Then, how do I convert to .csv automatically so
that I can import to sql server? Will I have to write a VB .dll, not
too hot with programming, so another solution would be preferrable.

any suggestions appreciated.

ally

What is in the .dat file? What is the format of the data?
extensions may not necessarily be representative of the data it contains.

Using FTP.exe and SQL Server agent (Scheduling mechanism) is a good way to
get things from an FTP site.



--

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


"Buttercup" <alison_clark20 (AT) hotmail (DOT) com> wrote