Post reply

Loading Intersystems Cache Data using SSIS Package.

  • June 3, 2011 at 8:35 am

    #252089

    Hi All ,

    I am facing a problem while Loading data from Intersystems Cache Database.

    i have to load the data by following query :

    SELECT FIELD FROM NMH.Table where Start_date < '20110601'

    It returns no rows.

    To which format i have to convert Date so that Cache Database understands. Anybody has any hands on Cache's Database how i format my Date parameter.

    Regards !

    Vineet

  • June 3, 2011 at 2:24 pm

    #1333932

    Try changing the date format to YYYY-MM-DD instead of YYYYMMDD. If that doesn't work - use the to_date function to convert the string value to a date.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • June 6, 2011 at 8:19 am

    #1334410

    Thanks a lot ! It solved issue.

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

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