Extracting File Name Data into a Table

[jconway]

I have a folder that includes very detailed file names. Each day I need to look at this folder and populate a table by parsing out the file name and looking at the owner, date, pages, etc. As a relative newbie to SSIS, I'm unsure of how to do this. Any steps people could give me in getting this done would be greatly appreciated!

Thanks,

Jen

 

[plevey]

Have a look at the SQL Position function. For example, find the position of the 'dot' delimiter of the file name and then the position of the first 'space' before the filename and so on.

If fishing was easy it would be called catching