Thanks in advance.

I have just read a post on www.sqldts.com titled "How can I change the
filename for a text file connection?". The example provided gives me
excellent detail on how to create a text file (destination) with a
changing name based on date which I currently use.

How do I reverse the principle and pull in a file with the following
properties:

\\Server\Directory\staticfilename_$%^*^#@)(&^(Rand om characters).txt

I need to do this now on a daily basis.

I currently use SQL 2000, but will move to SQL 2005 shortly. How do I
do this in both DTS and SSIS?

Mark Simmerman
Napa, CA
SQL Learner

Hi Mark,

There are a bunch of ways.
The easiest is probably to just use a ForEach loop (even if it only
runs once). Set the Enumerator to "Foreach File Enumerator", the
Folder to "\\Server\Directory\" and the Files to
"staticfilename_*.txt". This will loop through each file in the
directory that matches the specified pattern, set the file name (fully
qualified, name only or name and ext.) to a variable, and then run any
tasks inside the loop container.

Good luck!
J

Hi Mark,

There are a bunch of ways.
The easiest is probably to just use a ForEach loop (even if it only
runs once). Set the Enumerator to "Foreach File Enumerator", the
Folder to "\\Server\Directory\" and the Files to
"staticfilename_*.txt". This will loop through each file in the
directory that matches the specified pattern, set the file name (fully
qualified, name only or name and ext.) to a variable, and then run any
tasks inside the loop container.

Good luck!
J

Hi Mark,

There are a bunch of ways.
The easiest is probably to just use a ForEach loop (even if it only
runs once). Set the Enumerator to "Foreach File Enumerator", the
Folder to "\\Server\Directory\" and the Files to
"staticfilename_*.txt". This will loop through each file in the
directory that matches the specified pattern, set the file name (fully
qualified, name only or name and ext.) to a variable, and then run any
tasks inside the loop container.

Good luck!
J

Hi Mark,

There are a bunch of ways.
The easiest is probably to just use a ForEach loop (even if it only
runs once). Set the Enumerator to "Foreach File Enumerator", the
Folder to "\\Server\Directory\" and the Files to
"staticfilename_*.txt". This will loop through each file in the
directory that matches the specified pattern, set the file name (fully
qualified, name only or name and ext.) to a variable, and then run any
tasks inside the loop container.

Good luck!
J

Hi Mark,

There are a bunch of ways.
The easiest is probably to just use a ForEach loop (even if it only
runs once). Set the Enumerator to "Foreach File Enumerator", the
Folder to "\\Server\Directory\" and the Files to
"staticfilename_*.txt". This will loop through each file in the
directory that matches the specified pattern, set the file name (fully
qualified, name only or name and ext.) to a variable, and then run any
tasks inside the loop container.

Good luck!
J

Hi Mark,

There are a bunch of ways.
The easiest is probably to just use a ForEach loop (even if it only
runs once). Set the Enumerator to "Foreach File Enumerator", the
Folder to "\\Server\Directory\" and the Files to
"staticfilename_*.txt". This will loop through each file in the
directory that matches the specified pattern, set the file name (fully
qualified, name only or name and ext.) to a variable, and then run any
tasks inside the loop container.

Good luck!
J

Hi Mark,

There are a bunch of ways.
The easiest is probably to just use a ForEach loop (even if it only
runs once). Set the Enumerator to "Foreach File Enumerator", the
Folder to "\\Server\Directory\" and the Files to
"staticfilename_*.txt". This will loop through each file in the
directory that matches the specified pattern, set the file name (fully
qualified, name only or name and ext.) to a variable, and then run any
tasks inside the loop container.

Good luck!
J

Hi Mark,

There are a bunch of ways.
The easiest is probably to just use a ForEach loop (even if it only
runs once). Set the Enumerator to "Foreach File Enumerator", the
Folder to "\\Server\Directory\" and the Files to
"staticfilename_*.txt". This will loop through each file in the
directory that matches the specified pattern, set the file name (fully
qualified, name only or name and ext.) to a variable, and then run any
tasks inside the loop container.

Good luck!
J