Post reply

dBase import - null dates problem

  • July 2, 2003 at 2:47 am

    #106696

    I have an annoying issue with a dBase 5 import. The data is transformed in a standard manner -

    DTSDestination('x')=DTSSource('x')

    However, null dates in dBase are either true or false (inconsistently so)

    ie ISNULL(DTSDestination('x')) never returns null

    Has anybody come across this issue and resolved it (other than updating null values in the DBase table!)

    thanks

  • July 2, 2003 at 3:54 am

    #463885

    Have you tried using the ISDATE() function instead of ISNULL()?

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • July 2, 2003 at 7:09 am

    #463912

    If your importing you are checking DTSSource ;)]

    Why not use ActiveX for the column in question, ie

    

    Function Main()

    If DTSSource("x") = True Then

    DTSDestination("x") = null

    eElseIf DTSSource("x") = False Then

    DTSDestination("x") = null

    Else

    DTSDestination("x") = DTSSource("x")

    End If

    Main = DTSTransformStat_OK

    End Function

    Far away is close at hand in the images of elsewhere.
    Anon.

  • July 4, 2003 at 7:19 am

    #464186

    sorry guys

    just realised that I wrote null dates - it should have been null booleans - that was another issue!

    I have decided to update all NULL booleans in source table to FALSE, then migrating the data...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply