Are Loops possible in DTS Work Flows?

#1

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.

#2

lookat the www.sqldts.com web site
there is the solution

"jkiffer" <jkiffer (AT) discussions (DOT) microsoft.com> a écrit dans le message de
news: 50F053AD-84A6-460B-B650-7F2DB3DF4735...soft (DOT) com...

Quote:

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.

#3

In article <#689VcUnEHA.324 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, Jéjé wrote:

Quote:

lookat the www.sqldts.com web site
there is the solution

"jkiffer" <jkiffer (AT) discussions (DOT) microsoft.com> a écrit dans le message de
news: 50F053AD-84A6-460B-B650-7F2DB3DF4735...soft (DOT) 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.

More specifically

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

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

Are Loops possible in DTS Work Flows?

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

Are Loops possible in DTS Work Flows? - 09-17-2004 , 03:51 PM

Re: Are Loops possible in DTS Work Flows? - 09-18-2004 , 01:17 AM

Re: Are Loops possible in DTS Work Flows? - 09-18-2004 , 05:40 AM