How do I get a list of filenames from a populated folder?

• EamonSQL

  SSCrazy

  Points: 2307

  More actions

  August 30, 2005 at 10:39 am

  #87458

  Hi,

  can I run xp_cmshell to return a value of a filename that exists in a folder?

  I'm writing a script that will run a DTS package and would like to provide the filename as a parameter.

  As a follow on, the script will have a cursor that will loop through a number of filenames that might populate a folder.

  Any help welcome,

  Eamon

• Merrill Aldrich

  SSCrazy

  Points: 2358

  More actions

  August 30, 2005 at 11:25 am

  #586227

  Yes, I have done that. I generally make a temp table, then execute something like

  SET @listCom = 'DIR /b ' + @yourFolderName + '*.foo'

  INSERT INTO #dirlist ( fname ) EXEC master..XP_CMDSHELL @listCom

  Then you can query the table. Beware that the result set might just be "File Not Found"

• EamonSQL

  SSCrazy

  Points: 2307

  More actions

  August 30, 2005 at 12:03 pm

  #586255

  perfect !

  Thanks alot Merrill,

  Eamon