How do I fix ‘Invalid character value for cast specification’ on a date column in flat file?
I was ultimately able to resolve the solution by setting the column type in the flat file connection to be of type “database date [DT_DBDATE]” Apparently the differences between these date formats are as follow: DT_DATE A date structure that consists of year, month, day, and hour. DT_DBDATE A date structure that consists of year, … Read more