sql-server - ssis 包中 'drop table' 或 'drop index' 存在语法错误

Question

我正在使用 ssis 删除并重新创建 Excel 文件。我使用了 ExecuteSQLTask 并编写了 sqlstatement

drop table 'Employee'
go
CREATE TABLE `Employee` (
`BusinessEntityID` INT,
`JobTitle` NVARCHAR(50),
`BirthDate` DATE,
`MaritalStatus` NVARCHAR(1),
`Gender` NVARCHAR(1),
`HireDate` DATE
)

但是当我执行包时，我收到以下错误:

[Execute SQL Task] Error: Executing the query "drop table 'Employee' " failed with the following error: "Syntax error in DROP TABLE or DROP INDEX.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

请帮我解决这个问题。

Answer 1

删除字符 ` 并尝试

drop table [Employee]
go

CREATE TABLE [Employee] 
(
[BusinessEntityID] INT,
[JobTitle] NVARCHAR(50),
[BirthDate] DATE,
[MaritalStatus] NVARCHAR(1),
[Gender] NVARCHAR(1),
[HireDate] DATE
)