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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics