Scott In Sydney - Friday, July 21, 2017 8:43 AM

My actual question is resolved, but for completeness...

I will create the below SP:

ALTER PROCEDURE sp_DropTable (@tableName VARCHAR(255))
AS
BEGIN
  DECLARE @SQL VARCHAR(1000);
    SET @sql='BEGIN TRY
    IF EXISTS(
        SELECT 1 FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N''{0}'') AND type = (N''U''))
        BEGIN
            DROP TABLE {0}
            PRINT ''{0} dropped.''
        END
    ELSE
        BEGIN
            PRINT ''{0} does not exist.''
        END
END TRY
BEGIN CATCH
    PRINT ''Error dropping {0}''
END CATCH
'
    SET @sql=REPLACE(@sql,'{0}',@tableName)
    --PRINT @SQL;
    EXEC (@SQL);
END


Then in SSDT I will code my Execute SQL Task as:exec sp_DropTable ?

and map my tableName variable to Parameter 0.

Thanks for the help.