Get file name for a particular file type

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I'm looking to be able to get the filename of a file that is of a
particular type. I know that my DTS package is going to export a file
that has the time in the name of it (ex
CRB-UHCCIG6-5-2006-11h36m59s.edi), and i want to be able to auto zip
that file. Copying, zipping isn't a problem, it's finding out what the
file name is. Any suggestions?

Kelly

.

Relevant Pages

  • Re: DTS query result to file - can I loop it?
    ... How to loop through a global variable Rowset ... How can I change the filename for a text file connection? ... The values for @MyType are stored in a database table so a cursor ... > existing DTS package or will I have to create a new package to handle each ...
    (microsoft.public.sqlserver.dts)
  • Re: File Creation Not Working In A Thread Class?
    ... otherFile, fileName, pattern are names ... my crystal ball (whose predictions I don't usually report!) tells ... copying = False ... this works FINE outside the thread class. ...
    (comp.lang.python)
  • Re: File naming issue
    ... How can I change the filename for a text file connection? ... As for appending. ... I need to have a dts package that creates a text file dynamically to archive data from table.The file name needs to be in the format of currentdate_table.txt and only one file needs to be created per year.So if the DTS is on any day other than 1st jan then the data needs to be appended to the already existing file which was created the 1st day of that year.Is this doable and if so how? ...
    (microsoft.public.sqlserver.dts)
  • Automate Zipping of All Files in a Certain Directory Between Specific Dates
    ... consists of zipping all of the files in a certain directory which were ... Input #2: Filename In Which Files that are to be zipped reside (Say, ... or can anybody provide the link for a sample script? ...
    (microsoft.public.windowsxp.general)
  • Re: Determining when a file has finished copying
    ... You could also copy to a different name on the same disk, and when the copying ... has been finished just 'move' the file to the filename the other ... -- Mahatma Gandhi ...
    (comp.lang.python)