Unanswered: Table lock when importing data from Ms Access to SQL Server 2k
am trying to schedule a regular copy of an MS Access table into an SQL Server database using the DTS import. Now that Access table is constantly updated by another software. So when the package is run as a scheduled Job, it fails on an error that the Source table is exclusively locked by another user and so the data cannot be obtained.
All I need is a read-only access to the access database/table to copy the data into mine.
But where do i set the value for read-only, nolock access while configuring the DTS package?