Forum Discussion

wherdzik's avatar
wherdzik
Icon for Helper III rankHelper III
2 years ago
Solved

File Contains Corrupted Data - Error

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.

 

 

 

Need Help
  • BA_Pete's avatar
    BA_Pete
    2 years ago

    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

2 Replies

  • BA_Pete's avatar
    BA_Pete
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      wherdzik
      Icon for Helper III rankHelper III
      2 years ago

      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.