SQL Date question

[swoodring]

I am using sql server 7.0. I am using a dts to bring over data from sales files on our as/400. I have a date field format(2001-01-01) and a time field(13.00.00) which I would like to put together in a sql table as one field smalldatetime. (2001-01-01 13.00.00.000) Is this possible with a dts? The rest of the fields I'm brining over will basically just map to each other in other words straight copies.

Stacy

 

[foxdev]

You could use an ActiveX script for that particular column, or you could import into a staging table with each going into separate columns, then insert them into the final table concatenated, similar to:

insert into MyTable
select a, b, c, cast(d+' '+e as datetime)
from MyStagingTable
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org