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
No comments:
Post a Comment