DTS Package Date field transfer error

[bopritchard]

i'm running sqlserver 7 and I have a DTS package that transfers data from a flat file into a table in my database...

it keeps barfing trying to copy the date field from my flat file to my database...gives the following error
"Source column too narrow to contain a valid value of destination column's datatype for column pair"

the source file data is in the format 10/21/2003 and the destination field is of type datetime(8)

 

[mrdenny]

try loading the date field into a varchar field in a temp table, then moving it into the final table with the datetime field, using a convert statement on the field to change from convert to varchar. Make sure your varchar is set for 10 wide.

Denny