The Source and Destination datatypes has to be same length
In the component , Ensure Input and External Columns are the same fixed length and verify
hardcoded values doesn't exceed the datatype length values .
To resolve this , Drag the Derived column from the Toolbar Section.
Edit the Expression Property , drag the attributes from the Type cast Section appears in the right side.
(DT_STR,15,1252)CHARFTFILEDVALUE
E.g., DT_STR is varchar , 15 is the fixed length that will match to the desination,1252 is the default value ;CHARFTFILEDVALUE is the actual column name.
In the component , Ensure Input and External Columns are the same fixed length and verify
hardcoded values doesn't exceed the datatype length values .
To resolve this , Drag the Derived column from the Toolbar Section.
Edit the Expression Property , drag the attributes from the Type cast Section appears in the right side.
(DT_STR,15,1252)CHARFTFILEDVALUE
E.g., DT_STR is varchar , 15 is the fixed length that will match to the desination,1252 is the default value ;CHARFTFILEDVALUE is the actual column name.
No comments:
Post a Comment