File Contains Corrupted Data - Error

[wherdzik]

I am not sure what is going on.  I cannot get this pull from SharePoint folders to work. I did the same thing through Data Flows..I get data but when I use excel and do the same thing I get this error.  This is driving me bonkers, how do I figure out which file is the issue and how to rectify. This error is not helpful at all.

[BA_Pete · Accepted solution]

Hi @wherdzik ,

Does your SharePoint folder contain files of different types e.g. .xlsx, .csv etc.?

It's possible that when you run the SharePoint Folder Connector wizard, it's attempting to build the connection using the wrong file type connector.

Pete

[wherdzik]

Yes it does, I manged to filter out a lot of the files and I got it to work.  I think this was the issue.  Sorry I should have made a post back.