I have a flat file source that is storing the date in dd-mon-yy format. When I try to convert to database type dbdate I get an error. Can anyone help me develop a solution using SSIS to convert this before I load into a table?
Configure your Flat File data source to use whatever regional setting is appropriate on the column and store it into a date-column in your database. Then you can retrieve the dates in whatever format you want (using for example SET dateformat).