get text files from a folder

#1

Hi all!
I have a package that imports data from a text file, located in an specific
folder.
My problem is that many files can be inside the folder and their names are
unknown for me. How can I find out the name and quantity of files within the
folder, and use these informations into a dynamic task to start the import
process?
Thank you all in advance!
Eduardo

#2

You can install Perl package and do it by perl script. By perl you can check
the file names and quantity and rename the file names to meet your DTS
package needs. Then you can invoke the dtsrun by system("dtsrun ....") from
the perl script.

Mark

"Eduardo Greco" <eduardo (AT) persocom (DOT) com.br> wrote

Quote:

Hi all!
I have a package that imports data from a text file, located in an
specific
folder.
My problem is that many files can be inside the folder and their names are
unknown for me. How can I find out the name and quantity of files within
the
folder, and use these informations into a dynamic task to start the import
process?
Thank you all in advance!
Eduardo

#3

did you try the scripting.filesystemobject?

Ed

"Eduardo Greco" wrote:

Quote:

Hi all!
I have a package that imports data from a text file, located in an specific
folder.
My problem is that many files can be inside the folder and their names are
unknown for me. How can I find out the name and quantity of files within the
folder, and use these informations into a dynamic task to start the import
process?
Thank you all in advance!
Eduardo

#4

How to do it?

"Ed" <Ed (AT) discussions (DOT) microsoft.com> wrote

Quote:

did you try the scripting.filesystemobject?

Ed

"Eduardo Greco" wrote:

Hi all!
I have a package that imports data from a text file, located in an
specific
folder.
My problem is that many files can be inside the folder and their names
are
unknown for me. How can I find out the name and quantity of files within
the
folder, and use these informations into a dynamic task to start the
import
process?
Thank you all in advance!
Eduardo

#5

Or you could use this brilliant site ....

http://www.sqldts.com/default.aspx?246

"Eduardo Greco" <eduardo (AT) persocom (DOT) com.br> wrote

Quote:

How to do it?

"Ed" <Ed (AT) discussions (DOT) microsoft.com> wrote in message
news:E0C5A644-35E0-4DE6-8FD3-76CBAD5511BD (AT) microsoft (DOT) com...
did you try the scripting.filesystemobject?

Ed

"Eduardo Greco" wrote:

Hi all!
I have a package that imports data from a text file, located in an
specific
folder.
My problem is that many files can be inside the folder and their names
are
unknown for me. How can I find out the name and quantity of files
within
the
folder, and use these informations into a dynamic task to start the
import
process?
Thank you all in advance!
Eduardo

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

get text files from a folder

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

get text files from a folder - 01-14-2005 , 08:59 AM

Re: get text files from a folder - 01-14-2005 , 08:07 PM

RE: get text files from a folder - 01-14-2005 , 09:53 PM

Re: get text files from a folder - 01-15-2005 , 06:00 AM

Re: get text files from a folder - 01-15-2005 , 10:25 AM