> I'm ftp'ing a set of csv files from a unix workstation to a cache
> directory
> on the local SQL Server. The file names are unknown since the names
> contain
> an arbitrary time of when they are generated on the Unix station. I've
> created an ActiveX script task that searches the cache directory and sets
> the
> datasource of a text file (source) connection to the file name. I then
> use a
> transform data task to put the data in a SQL Server table. The problem is
> that I may have multiple files that I need to import into the table. Is
> it
> possible to loop back from the SQL Server destination connection to the
> ActiveX script to continue loading csv files until none are left?
>
> The flow I desire looks like this:
>
> ActiveX Script----on success--->Text File Data (Source)----->
>
> transform data task------>SQL Server Connection----->ActiveX Script (back
> to
> beginning)
>
>
> I've tried the above, but there is no execution of any of the steps.

In article <#689VcUnEHA.324@TK2MSFTNGP11.phx.gbl>, Jéjé wrote:
> lookat the www.sqldts.com web site
> there is the solution
>
> "jkiffer" <jkiffer@discussions.microsoft.com> a écrit dans le message de
> news: 50F053AD-84A6-460B-B650-7F2DB3DF4735@microsoft.com...
> > I'm ftp'ing a set of csv files from a unix workstation to a cache
> > directory
> > on the local SQL Server. The file names are unknown since the names
> > contain
> > an arbitrary time of when they are generated on the Unix station. I've
> > created an ActiveX script task that searches the cache directory and sets
> > the
> > datasource of a text file (source) connection to the file name. I then
> > use a
> > transform data task to put the data in a SQL Server table. The problem is
> > that I may have multiple files that I need to import into the table. Is
> > it
> > possible to loop back from the SQL Server destination connection to the
> > ActiveX script to continue loading csv files until none are left?
> >
> > The flow I desire looks like this:
> >
> > ActiveX Script----on success--->Text File Data (Source)----->
> >
> > transform data task------>SQL Server Connection----->ActiveX Script (back
> > to
> > beginning)
> >
> >
> > I've tried the above, but there is no execution of any of the steps.
>