How to connect share point location from SSIS package to read and write for Microsoft access file.

Bala P 0 Reputation points
2024-04-08T14:31:52.76+00:00

Hi,

I have mdb file in share point location, So, I have to read the file as source reference and need update the same file as per SQL table in SSIS package.

I want create a connection string to get the connection for that URL(http://....)

Please help me on this.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,756 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,456 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,126 Reputation points
    2024-04-09T02:33:43.01+00:00

    Hi @Bala P,

    You may download the mdb file and then connect to the files with OLEDB source.

    User's image

    https://www.techbrothersit.com/2016/07/how-to-download-file-from-sharepoint-by.html

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments