find number in a text file

• bmr270

  Default port

  Points: 1477

  More actions

  August 19, 2008 at 8:37 am

  #123957

  I have exported data from 100 text files to SQL Server DATABASE and copied all the files into "D:\processedFiles" folder. We have SSN(number) and person details in each file. I want to find the text file name in "D:\processedFiles" folder for given SSN(number), example '000-00-1234'? How do I do in SSIS?

• stevefromOZ

  SSC-Forever

  Points: 43646

  More actions

  August 19, 2008 at 9:07 am

  #860071

  how would you do this? you'd put a for each file looping task in there and stop the data flow (read) operation when you hit the right number.

  Why would you do this? I have no idea why you wouldn't simply query the original data source in the DATABASE and get a result so much faster.

  Steve.