字段定义SSIS中的语法错误 [英] Syntax error in field definition SSIS
问题描述
您好我正在尝试使用SSIS将一些数据导出到excel文件。但是当我到达Excel目标组件中的创建表屏幕时,在输入我的脚本后,系统会将错误消息提示为上面的标题。以下是我在创建表格屏幕中的脚本:
创建 TABLE componentReport(
WorkNumber VARCHAR ( 20 ),
UnitDateEnd DATETIME2( 3 ),
UnitDateCreated DATETIME2( 3 ),
UnitId BIGINT ,
Track INT ,
SupplierName VARCHAR ( 50 ),
阶段 INT
)
我尝试过:
将VARCHAR更改为String / TEXT但相同,删除了任何可能的括号。
VARCHAR,DATETIME2,BIGINT和INT do不存在为Excel目标数据类型。
请参阅documentati on - Excel目的地 [ ^ ]
试试
CREATE TABLE componentReport(
WorkNumber NVARCHAR ( 20 ),
UnitDateEnd DATETIME ( 3 ),
UnitDateCreated DATETIME ( 3 ),
UnitId LONG,
跟踪INTEGER,
SupplierName NVARCHAR ( 50 ),
Stage INTEGER
)或者尝试导出为CSV或XML而不是Excel二进制文件 - 从内存中Excel驱动程序有点不稳定
Hi I am trying to export some data to excel file using SSIS. But when I reached the "Create Table" screen in Excel Destination component, after I have enter my script, the system prompt me the error message as title above. Below are my script in "Create Table" screen:
CREATE TABLE componentReport(
WorkNumber VARCHAR(20),
UnitDateEnd DATETIME2(3),
UnitDateCreated DATETIME2(3),
UnitId BIGINT,
Track INT,
SupplierName VARCHAR(50),
Stage INT
)
What I have tried:
Changed the VARCHAR into String/TEXT but the same, removed any possible brackets.
VARCHAR, DATETIME2, BIGINT and INT do not exist as Excel Destination data types.
See the documentation - Excel Destination[^]
Try
CREATE TABLE componentReport( WorkNumber NVARCHAR(20), UnitDateEnd DATETIME(3), UnitDateCreated DATETIME(3), UnitId LONG, Track INTEGER, SupplierName NVARCHAR(50), Stage INTEGER )Alternatively try exporting to a CSV or XML rather than an Excel Binary - from memory the Excel drivers were a bit flaky
这篇关于字段定义SSIS中的语法错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!