I know this is an old post, my apologies. I had this same issue... so I did the above suggestion and set the Logon account for the SQL Server...

David, thanks for the help, that article is what I am really after. I am wanting a solution that hits on the tables needed all through one view.

Thanks again.

Can you provide examples? In past my tables are at a week level and there isn't any actual datetime data types, just int. i.e. Year=2014 Week = 5

I had the same issue and was getting stressed out by this. I mistakenly set my File System Task operation to 'Delete File', which to a normal syntax of...