question

Lpas-2109 avatar image
0 Votes"
Lpas-2109 asked Zoehui-MSFT commented

Ssis odbc connectivity

Hi

I use MS Access and make an ODBC connection to generate reports ,but now I would like to export data through SSIS. My question is can I make the same ODBC connection(read only) credentials to my SSIS and export data.

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered Zoehui-MSFT commented

Hi @Lpas-2109,

Open Database Connectivity (ODBC) is a protocol that you can use to connect a Microsoft Access database to an external data source such as Microsoft SQL Server.

For more details you may refer: administer-odbc-data-sources

odbc-connection-manager

In addition, you may also use OLEDB to connect to an Access Database.

How to: Connect to an Access Database

Regards,

Zoe


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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

0 Votes 0 ·