Currently when using DTS, I am doing so using the wizard. All I do is choose a source, namely the text flat file on the server and then I select the fixed field format and then set the columns. After that I choose the destination SQL Server.

At this point I have tried to transform the data as listed below:

DTSDestination("INVOICE_DATE") = DTSSource("Col004")

I changed the above statement to:

DTSDestination("INVOICE_DATE") = CDATE(DTSSource("Col004"))

Neither of these two statements worked. I do not see any "DateTime String" option available. Please tell me if I am missing something.

Thanks