Re: FTP .cvs files from Unix and import to SQL server.

#1

Your script should use mget as part of the FTP script, it will get all
files, mget *.*.

Adrian

jkiffer wrote:

Quote:

I understand the basics of using the FTP task and data transformation with
.cvs files, but am looking for a more robust solution. I need to do the
following:
1. FTP ".cvs" files from a Unix box. The files reside in a cache directory
and any files that exist at the execution of the task must be ftp'd. The
names of the files are indeterminate.

2. The .cvs files from above all have the same format. I need to setup a
connection to the file retrieved from the above step and then perform simple
data transformation of mapping the file field for field into a SQL Server
table.

I understand how to do both steps when the name of the file is known.
Unfortunately the name of the files are unknown and accumulate on the Unix
box over the course of a day. Any help would be appreciated!

jeremy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: FTP .cvs files from Unix and import to SQL server.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: FTP .cvs files from Unix and import to SQL server. - 09-17-2004 , 10:03 AM