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
Excel 2005 file to SQL server 2005
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: