I have an Azure SQL DB database that I am copying data into from a source database using SSIS. My SSIS package for one table fails because it can't write to or create a specific table name (it is important to keep the same table names as in the source database). I attempted to address the problem via an SQL query, but
CREATE TABLE [schemaname].[tablename]
There is already an object named 'tablename' in the database.
DROP TABLE [tablename]
Cannot drop the table 'tablename', because it does not exist or you do not have permission.
I have had a look at a few posts where other people have had similar problems, but the solutions offered are either not possible in this situation or do not work: I am already accessing the database with the admin account, and there are no tables with the same name as this in any other schema either. Dropping the table if it exists gives the same error, and FLUSH TABLES seems to be MySQL-specific so does not work. Because it is an Azure database, I can't access the back-end filesystem, and the database is too large to easily move or copy anywhere else.
Does anyone have any ideas as to how to resolve this?