I am trying to import a text file into SQL with DTS and I am having trouble transforming the date field. In the text file they look like 11-Jan-2005 and they are going to 1/11/05 in SQL. SO in the source date format I have dd-MMM-yyyy and in the Destination I have M/d/yy. But it is still not working. I get the error "The number of failing rows exceeds maximum specified. TransformDateTimeString, column pair1(source column 'Col030' DBTYPE_STR, destination column 'InsuranceExp' DBTYPE_STR)) Cannot convert source to datetime. HELP?????
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DTS Date Transformation
- Thread starter andis
- Start date
Similar threads
- Locked
- Question
- Locked
- Question