ok, probably a daft question this, but I'll ask anyway......
I've the following running on my SQL Server:
1) A stored procedure is called to executed a DTS Package.
2) The DTS Package drops some tables, recreates them and then imports in the latest data from our AS/400.
3) A scheduled Merge Replication runs to merge the tables from the SQ Server and the versions of the tables running on my local laptop.
However, when the stored procedure is called to execute the DTS Package I get the following error in the DTS Package Logs:
Step Error Source: Microsoft OLE DB Provider for SQL Server
Step Error Description:Cannot drop the table 'emtdaily.dbo.EMTCONTROL' because it is being used for replication.
Step Error code: 80040E14
Step Error Help File:
Step Error Help Context ID:0
Now I know the message says it all - "Cannot drop the table 'emtdaily.dbo.EMTCONTROL' because it is being used for replication" - but is there anyway round this? Or is my only solution to simply delete all records from the tables, rather than deleting the table itself, and then import the data from the AS/400?