title: Exporting PDF's from SQL Server DB and writing a Map to a Text File
body: <p>I need to write an application or Query to export a large amount of PDF's to file and create a delimited text file that shows where the files are and contains the ID of the record.</p>
  
  <p>what I was thinking about doing was using a console application that would write the entry to the text file after exporting the PDF from the DB, that way I would have all the information together when writing the Text File so that I could make sure that all the Data in the Delimited text file was accurate. </p>
  
  <p>at first I was thinking about using a Dataset to do this, but there are going to be more than 50,000 rows of Data.  I am not so sure that a DataTable would be any better</p>
  
  <p>I was also looking into using the BCP utility,  but from what I was reading the export doesn't give me a PDF File back from the Data, is this true?</p>
  
  <p>I would probably consider myself a beginner, programming something like this. 
  what should I use for a Data Structure like this?  would I use a Cursor, and if so how would I set it up to fit what I am doing?</p>
  
  <p><strong>Update</strong></p>
  
  <p>I am going to try and use the DataSet option, but limit it to 1 days worth of data at a time using a do while loop, so that I can loop through every day from the beginning of the data until today's date.  so I will do a days worth of Data and then get rid of the DataSet, then do the next date.</p>
  
  <p>does anyone see anything in my Logic that would cause issues?</p>