Connecting to secured Access DB 1

[Chanbo]

I am new to SSIS, want to connect to an Access DB on a secured network share. What connection info do I need?

 

[Catadmin]

You'll need to get with the owners of the Access DB to get Security access on the secured share as well as access for the domain user account you'll be running the SSIS package as. Then, you'll need the usual ODBC stuff to create an ODBC connect from SSIS to the Access DB.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Chanbo]

I contacted my Support staff and they recommended getting a service account set up that had the appropriate permissions to that share on the network. I will figure out how to launch the SSIS package under that login.
Thanks for the assist!

 

[Catadmin]

NP. Let us know if you need anything else.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Chanbo]

Will do.