How do we use the file system object to loop through a directory and refresh all the files?

[Ajay Garg]

I wanted to loop through a directory and get the names of all the
files in the directory and put it in a table using the file system
object and VB scrip in a DTS package...
How can Ido this?
Thansk in advance.
Ajay

[Steven Burn]

<%
Dim FSO
Dim Fl
Dim Fls
Set FSO = CreateObject("Scripting.FileSystemObject")
Set Fls = FSO.GetFolder(Server.MapPath("./")) './ is the current folder

For Each Fl in Fls
Response.Write Fl.Name & "<br>"
Next

Set Fl = Nothing
Set Fls = Nothing
Set FSO = Nothing
%>
--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)
Ajay Garg <aj*****@hotmail.com> wrote in message
news:d9**************************@posting.google.c om...

I wanted to loop through a directory and get the names of all the
files in the directory and put it in a table using the file system
object and VB scrip in a DTS package...
How can Ido this?
Thansk in advance.
Ajay

[Brynn]

Try this function out, it will return an single-dimensional array with
all of the file names.
http://www.coolpier.com/cp/cp_script....asp&view=code
Brynn
www.coolpier.com

On 13 Jan 2004 17:18:41 -0800, aj*****@hotmail.com (Ajay Garg) wrote:

I wanted to loop through a directory and get the names of all the
files in the directory and put it in a table using the file system
object and VB scrip in a DTS package...
How can Ido this?
Thansk in advance.
Ajay

I participate in the group to help give examples of code. I do not guarantee the effects of any code posted. Test all code before use!

Brynn
www.coolpier.com

[spdl]

Would there be a way to get all hierachies and not only one level?

ralph

"Brynn" <[e-mail]> wrote in message
news:40**************@news.comcast.giganews.com...

Try this function out, it will return an single-dimensional array with
all of the file names.
http://www.coolpier.com/cp/cp_script....asp&view=code

Brynn
www.coolpier.com

On 13 Jan 2004 17:18:41 -0800, aj*****@hotmail.com (Ajay Garg) wrote:

I wanted to loop through a directory and get the names of all the
files in the directory and put it in a table using the file system
object and VB scrip in a DTS package...
How can Ido this?
Thansk in advance.
Ajay
I participate in the group to help give examples of code. I do not

guarantee the effects of any code posted. Test all code before use!
Brynn
www.coolpier.com

[Curt_C [MVP]]

make the call recursive, having each subdir call the function again

--
Curt Christianson
Owner/Lead Developer, DF-Software
www.Darkfalz.com
"spdl" <sp**@mosaic.ca> wrote in message
news:O4**************@tk2msftngp13.phx.gbl...

Would there be a way to get all hierachies and not only one level?

ralph

"Brynn" <[e-mail]> wrote in message
news:40**************@news.comcast.giganews.com...

Try this function out, it will return an single-dimensional array with
all of the file names.

http://www.coolpier.com/cp/cp_script....asp&view=code

Brynn
www.coolpier.com

On 13 Jan 2004 17:18:41 -0800, aj*****@hotmail.com (Ajay Garg) wrote:

I wanted to loop through a directory and get the names of all the
files in the directory and put it in a table using the file system
object and VB scrip in a DTS package...
How can Ido this?
Thansk in advance.
Ajay

I participate in the group to help give examples of code. I do not

guarantee the effects of any code posted. Test all code before use!

Brynn
www.coolpier.com

[spdl]

Do you know about an example for this. Sounds rather complicated...

thanks

"Curt_C [MVP]" <software_AT_darkfalz.com> wrote in message
news:e2****************@TK2MSFTNGP11.phx.gbl...

make the call recursive, having each subdir call the function again

--
Curt Christianson
Owner/Lead Developer, DF-Software
www.Darkfalz.com
"spdl" <sp**@mosaic.ca> wrote in message
news:O4**************@tk2msftngp13.phx.gbl...

Would there be a way to get all hierachies and not only one level?

ralph

"Brynn" <[e-mail]> wrote in message
news:40**************@news.comcast.giganews.com...

Try this function out, it will return an single-dimensional array with
all of the file names.

http://www.coolpier.com/cp/cp_script....asp&view=code

Brynn
www.coolpier.com

On 13 Jan 2004 17:18:41 -0800, aj*****@hotmail.com (Ajay Garg) wrote:

>I wanted to loop through a directory and get the names of all the
>files in the directory and put it in a table using the file system
>object and VB scrip in a DTS package...
>
>
>How can Ido this?
>
>
>Thansk in advance.
>
>
>Ajay

I participate in the group to help give examples of code. I do not

guarantee the effects of any code posted. Test all code before use!

Brynn
www.coolpier.com