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?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.