SQLTeam.com | Weblogs | Forums

Insert multiple pdf files to sql database



I have a local folder which contains pdf files copied from an ftp server. What I want to do is to insert those to an sql database. I have already done it with one pdf file, however I am thinking, is it possible to use a looping statement so that a stored procedure will automatically insert all pdf files that are inside the folder and stop when everything is inserted ? Thank you.


This is really a job for the SSIS For Each File loop