sql server dts: I'm new to SSIS and I'm trying to rebuild a sql 2000 dts package that
imports a text file. This file has a field that is a string that is a
date timestamp. The field looks like this: 20050622180517 in this
format yyyyMMddHHmmss. In my sql 2000 dts, i use a date time string
transformation to put it in this format: MM/dd/yyyy HH:mm:ss. I do
that so that it can be loaded as a datetime into my sql table. I'm at
a loss on how to do this in SSIS, any help would be greatly
appreciated.

Thanks in advance,
David

Hello David,

To transform string field into corresponding format you can use Script
Component included in Data Flow Component of SSIS.
In the script you generate new column containing date in appropriate
format.
Here is an example of this function:

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As
Input0Buffer)

Dim StrDate as StringStrDate = Mid(Row.Date1, 5, 2) &
"/"StrDate = StrDate & Mid(Row.Date1, 3, 2) & "/"

StrDate = StrDate & Mid(Row.Date1, 1, 2)

If IsDate(StrDate)Then
Row.Date2 = CDate(StrDate)
End If
End Sub

I hope it will be helpful.

Best regards,
Radoslaw Lebkowski


[quoted text, click to view]