ssis transform task 1

[chunkydrew65]

I have a SQL 2000 dts package which I'm trying to convert to a SQL 2005 SSIS package. It seems simple enough, but I can't figure it out. I have several date fields in a fixed-width text file which are in mainframe yyyymmdd format. I need to convert them into SQL MM/dd/yyyy format. In 2000, I used left$, mid$ and right$ in vbscript to do the conversion, then concatenated them together with '/' between. I just cannot find any documentation how to do the same thing in 2005. Can anyone help me? Do I need a transform task, a script task, a combination of both, or something else?

 

[RiverGuy]

In your Data Flow task, you can add a Derived Column task, and use and expression to create your date field.