Excel Share point file to SSIS

[sabd80]

Hi Guys,

I am trying to connect to an excel file, that is on sharepoint, in SSIS, but I get below error when I try to test the connection:

[v-yanjiang-msft]

Hi @sabd80 ,

There may be a few different things that could be causing this error. Here are a few things you might want to check:

- Make sure that the file path you're using to connect to the Excel file is correct. Double-check that you're using the correct server name, site name, and document library name, as well as the correct file name and extension.

- Make sure that the SharePoint site is accessible from the machine where you're running SSIS. You may need to check your network settings or firewall rules to ensure that you're able to connect to the site.

- Make sure that you have the correct permissions to access the Excel file. Depending on how your SharePoint site is set up, you may need to be added to a specific group or have certain permissions in order to access the file.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sabd80]

Thanks @amitchandak , I will try another forum.

I have installed the drivers now, but I get below error:
Test connection failed -> The sign-in name or password does not match one in the Microsoft account system.

I do have access to the folder and the file

[amitchandak]

@sabd80 , This is not the correct forum for that.

Seem like the required driver is not installed