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