Does anyone know how to get around the exclusive lock DTS wants to get on free FoxPro tables? I can do a copy of the table so that DTS is happy but I want to replicate on a scheduled basis with as few differences as possible. Maybe there is some setting I can make on the SQL Server 7.0?
