I am converting a flat file as fixed width using ssis. I have the package built but instead of running a sql after the package builds the table, I would like to do all the cast and converts in the package.
How in the ssis package can I do a convert of varchar(6) to datetime? 121806 to 12/18/06
How about money datatype? 000012345 to 0000123.45
Can this be done in the create table part of the package?