Merge data and Time fields

[ohmbru2]

I have a DTS package where there is a Date and a Time (separate fields). I want to create 1 field out of them and continue to transform them separarely.

I've tried to concatenate them, like this:

DTSDestination("swdatetime") = DTSSource("Col002")) & DTSSource("Col003")

That didn't work so I tried this:

DTSDestination("swdatetime") = DatePart("m", DTSSource("Col002")) & "/" & DatePart("d", DTSSource("Col002")) &, etc.

Any ideas how I can accomplish this?

 

[xwb]

Try using value

DTSDestination("swdatetime").value = DTSSource("Col002").value & DTSSource("Col003").value

 

[PHV]

Provided the fields are real DateTime fields, you may try this:
DTSDestination("swdatetime") = DTSSource("Col002") [!]+[/!] DTSSource("Col003")

Another way:
DTSDestination("swdatetime") = CDate(DTSSource("Col002")) + CDate(DTSSource("Col003"))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886