PS if this is posted on google as well pardon duplication.

Inside my ActiveX of my DTS package I am trying to scroll through my
directory and based on FileExtension process or move file to archive.

I want if the file is a dbf extension and not a i.dbf and d.dbf to
process the file otherwise move the file to archive.
I do a stripofffileextexsion to get they i.dbf and d.dbf
I have mulitple dbf files
matta.dbf
mattb.dbf
mattd.dbf
matti.dbf
etc...
If the file is not a dbf extension then move to archive directory.

so here is my if statement that I use as I only want to process correct
dbf.

if DTSGlobalVariables("gv_FileExtension").Value = "dbf" or
(StripOffFilePart( DTSGlobalVariables("gv_FileFullName").Value,".") <>
"i.dbf" or StripOffFilePart(
DTSGlobalVariables("gv_FileFullName").Value,".") <> "d.dbf") Then

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi mattew,
For this you can use FSO to select which file you want to process or
archive.
http://www.tutorial-web.com/asp/fso/...?property=Name
JFB


"matthew larson" <mattclarson (AT) hotmail (DOT) com> wrote