dbTalk Databases Forums  

Get file name for a particular file type

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


Discuss Get file name for a particular file type in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default Get file name for a particular file type - 06-06-2006 , 09:39 AM






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


Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Get file name for a particular file type - 06-06-2006 , 10:04 AM






Hello KellyLeia (AT) gmail (DOT) com,

Loop through the directory and look for a file with that extension

Here's an idea

http://www.ostrosoft.com/vb/projects...yExt/index.asp

Allan

Quote:
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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.