Excel 2005 file to SQL server 2005

gooogle · Post by **gooogle** » Mon Jul 12, 2010 1:23 pm

I have a excel file with column [Names](names in it). I am sending this file to target SQL 2005 table with column [Names] (names in it) varchar 64.

In the transformer:
XLS [Names] had varchar 244 | SQL [Names] has varchar 64
I changed XLS to varchar 64

Now if I add a new name to the XLS. DataStage wont send this new row across, it will only send the 1st row.

Error is: MetaData mismatch
COLUMN.PRECISION Expected = 64 Actual = 255

How to change Excel file that way if I add any new rows to the Excel file it should update the SQL table as well ?

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon Jul 12, 2010 3:53 pm

I don't believe you can make this change at the Excel side. But you *could* make the output of the Transformer Varchar(255) to get the metadata to match.