Yes I am just just doing a simple select from the database and it tells me access is denied. I want to still be able to access the database when my SSIS package is running. Sorry, I am new to FoxPro.
I am using the Foxpro OleDB Provider in the SSIS, and I have "Share Deny None" in permissions, but when I am running the SSIS package... I am unable to access the database still
Hi,
I am creating an SSIS package where I am pulling data from tables on foxpro and putting the data into a table in SQL. Is there a way to make sure the table does not lock when I am pulling the data from FoxPro so other users can still access the table?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.