DIF (Data Interchange Format) file format via SSIS

  • Have anyone work with this file format in SSIS.

    I am migrating a DTS package to SSIS one.

    In the DTS, they use the DIF file format (Data Interchange Format).

    I tried ODBC and Excel Source in the SSIS but still no luck.

    Here is the dif file sample:

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

    TABLE

    0,1

    "EXCEL"

    VECTORS

    0,2

    ""

    TUPLES

    0,6

    ""

    DATA

    0,0

    ""

    -1,0

    BOT

    1,0

    "Chg User"

    1,0

    "Addr#"

    1,0

    "FieldName"

    1,0

    "Old Value"

    1,0

    "New Value"

    1,0

    "Chg Date"

    -1,0

    BOT

    1,0

    "agk"

    1,0

    "agk"

    1,0

    "agk"

    1,0

    "abc"

    1,0

    "abc"

    0,11/27/2009 16:37

    V

    -1,0

    EOD

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

Viewing post 1 (of 1 total)

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