Date Concatenation

Working with an archaic mess of Access dbs, and am trying to convert to a single SQL Server 2005 db.

A couple of places in the original monstrosity I have the time and date in separate columns, like the following example:

[Ticket Date] [Ticket Time]
12/1/99 0845
12/2/01 0932

One problem is the two columns can be of different data types, like a date col and a text time. If anyone knows how to bring these into a single column using SSIS, I would love to know since I have been battling with it for a while.

Use the Derived Column component. Cast them as strings and then its just a string a manipulation problem.

-Jamie

Date and time Concatenation

Hello,

I have 2 columns in a table, one with date ("M/DD/YYYY" format) one with time ("HH:MM" format)

How can i do to make one date column in "DD/MM/YYYY HH:MM:SS" format ?

Thanks a lotHave a look here: http://blogs.conchango.com/jamiethomson/archive/2005/07/26/1867.aspx

-Jamie