Column Length

[mekohler]

I'm importing a table using an OBDC connection. I drop the existing table and bring in the new table, but I keep getting the warning message that:
[OLE DB Destination [192]] Warning: Truncation may occur due to inserting data from data flow column "Copy of NAPSTC" with a length of 15 to database column "NAPSTC" with a length of 10.
Where is the column width set? I tried using data conversion, mapping the column to a larger text column, but that didn't change anything.
Thanks,
Michael Kohler

 

[mekohler]

I've got it to work, the mapping of the columns was incorrect. I made sure the correct column was mapped right and the the package works without any errors or warnings.
Michael Kohler