import subset of text files in a directory

#31

On Jul 7, 7:47*am, jhofm... (AT) googlemail (DOT) com wrote:

Quote:

Hi Klein,

The active-x scripting to implement looping in DTS isn't actually all
that hard ... iirc you just need to set the task which is the start of
the loop status to "waiting" (or "ready" ... I forget the exact status
description but there are many examples on the internet

) *All
subsequent tasks just run in sequence.

Just imagine you're writing an old-school process with IF's and GOTO's
as your only flow controls

Good luck!
J

Thanks. :-)

K

#32

On Jul 7, 7:47*am, jhofm... (AT) googlemail (DOT) com wrote:

Quote:

Hi Klein,

The active-x scripting to implement looping in DTS isn't actually all
that hard ... iirc you just need to set the task which is the start of
the loop status to "waiting" (or "ready" ... I forget the exact status
description but there are many examples on the internet

) *All
subsequent tasks just run in sequence.

Just imagine you're writing an old-school process with IF's and GOTO's
as your only flow controls

Good luck!
J

Thanks. :-)

K

#33

On Jul 7, 7:47*am, jhofm... (AT) googlemail (DOT) com wrote:

Quote:

Hi Klein,

The active-x scripting to implement looping in DTS isn't actually all
that hard ... iirc you just need to set the task which is the start of
the loop status to "waiting" (or "ready" ... I forget the exact status
description but there are many examples on the internet

) *All
subsequent tasks just run in sequence.

Just imagine you're writing an old-school process with IF's and GOTO's
as your only flow controls

Good luck!
J

Thanks. :-)

K

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

import subset of text files in a directory

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

Re: import subset of text files in a directory - 07-07-2008 , 04:49 PM

Re: import subset of text files in a directory - 07-07-2008 , 04:49 PM

Re: import subset of text files in a directory - 07-07-2008 , 04:49 PM