"Gil Yoktan" <gil@tadiad.co.il> wrote in message
news:OgXyar8qFHA.2540@TK2MSFTNGP09.phx.gbl...
> SQL-SERVER 2000
> Hello - I want to import data from a paradox table. In this pdx table I
> found 2 fields: one for Date defined as pdx Date datatype and one for Time
> defines as pdx Time datatype. I cannot change that. I built a DTS - which
> fails on the Time field (defined as SmallDateTime in the SQLServer
> destination table). My problem is how to let DTS insert the Time value
> into
> a SmallSateTime MSSQL field ?
> I tried concatenation, I tried using "convert" to convert the date source
> field in a varchar and then concatenating it
> All my attempts failed. Myabe you know how to do it ?
> (BTW - I don't mind which date is put in the "Date" part of the field
> value
> as I want to extract the time part programmatically, eventhough it could
> be
> nice to have the contents of the "Date" field there...
> Thanks in advance Gil Yoktan
>
>

"Gil Yoktan" <gil@tadiad.co.il> wrote in message
news:%23aHApxErFHA.3080@TK2MSFTNGP15.phx.gbl...
> Thanks for your response
>
> I tried changing the main SQL from
> DTSDestination("Start_Date") = DTSSource("Start_Date")
> DTSDestination("Start_Time") = DTSSource("Start_Time")
> to
> DTSDestination("Start_Date") = DTSSource("Start_Date")
> DTSDestination("Start_Time") = DTSSource("Start_Date") +
> DTSSource("Start_Time") - no luck
>
> and to
> DTSDestination("Start_Date") = DTSSource("Start_Date")
> DTSDestination("Start_Time") = convert(varchar, DTSSource("Start_Date"),
> 10) + DTSSource("Start_Time") - no luck
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***