Excel Destination Error
hi experts, I'm trying to load result of a query to Excel destination. ... when I create a new connection manager and a new table... The error : "the table cannt be created...syntax error in field definition" appears...any sugesions to deal with this error...
thanks vishal
February 28th, 2011 12:50pm
Hello Vishal,
Why don't you use the Excel destination?
Besides, the error points to a wrong SQL syntax.
Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
February 28th, 2011 12:54pm
hi arthur... I'm using Excel Destination and This is the create Table Syntax in excel dest... and still the error persists :
CREATE TABLE `Excel Destination` (
`car_id` BIGINT,
`car_LastName` NVARCHAR(50),
`car_FirstName` NVARCHAR(50),
`car_MiddleName` NVARCHAR(50),
`car_StatusID` INT,
`car_BranchID` INT,
`car_Title` NVARCHAR(50),
`car_SkillCd` INT,
`car_Address1` NVARCHAR(255),
`car_Address2` NVARCHAR(60),
`car_City` NVARCHAR(50),
`State` NVARCHAR(20),
`car_PostalCode` NVARCHAR(20),
`car_County` NVARCHAR(50),
`car_Country` INT,
`car_Email1` NVARCHAR(50),
`car_Birthdate` DATETIME,
`car_Notes` NVARCHAR(4000),
`car_Role` SMALLINT,
`car_LegacyBranchID` INT,
`car_EmpSSN` BINARY(255),
`carhr_hiredate` DATETIME,
`carhr_startdate` DATETIME,
`carhr_OrientationDate` DATETIME,
`phone` NVARCHAR(32),
`altphone` NVARCHAR(32),
`workphone` NVARCHAR(32),
`cellphone` NVARCHAR(32),
`sch_StartTime` DATETIME,
`sch_EndTime` DATETIME
)
February 28th, 2011 12:58pm