Re: Handling Files in DTS

#1

Yep.

Add a qualifier when you pick up the files to say

for each fil in fold.files
if fso.GetExtensionName(fil) = "EXTENSION" THEN
Do Something
End if
Next

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Matt L" <mattclarson (AT) hotmail (DOT) com> wrote

Quote:

I have developed a DTS package ,with the help of Allan Mitchell-Thanks
Allan!, that loops through an assigned directory and loads the file
types designated to the appropriate table. The question that I have is
in DTS is there a way when looking at a particular extension to skip
by that file and move on to the next one and when all of the other
files are loaded and moved to their archive directory to stop the DTS
package leaving only the designated files with a certain extension in
the directory. (Sorry all I am a beginner in SQL Server and in DTS)

Thanks,

Matt

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

Re: Handling Files in DTS

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

Re: Handling Files in DTS - 08-13-2003 , 09:20 AM