Home Forums SQL Server 2012 SQL Server 2012 - T-SQL OPEN TEXTFILE FROM T-SQL RE: OPEN TEXTFILE FROM T-SQL

  • October 17, 2017 at 8:50 pm

    #1964139

    unas_sasing - Tuesday, October 17, 2017 8:45 PM

    I have this flow:

    bUt always get error:

    And when I fix the error, but still I got the same error..

    this is the Flatfile source:

    "Name"    "Data Type"    "Precision"    "Scale"    "Length"    "Code Page"    "Sort Key Position"    "Comparison Flags"    "Source Component"
    "MemberXID"    "DT_I2"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "MemberProfileXID"    "DT_I1"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "MemberID"    "DT_I4"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "FirstName"    "DT_STR"    "0"    "0"    "30"    "1252"    "0"    ""    "Flat File Source"
    "MiddleName"    "DT_STR"    "0"    "0"    "20"    "1252"    "0"    ""    "Flat File Source"
    "LastName"    "DT_STR"    "0"    "0"    "255"    "1252"    "0"    ""    "Flat File Source"
    "Alias"    "DT_STR"    "0"    "0"    "255"    "1252"    "0"    ""    "Flat File Source"
    "BirthDate"    "DT_I4"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "Email"    "DT_STR"    "0"    "0"    "30"    "1252"    "0"    ""    "Flat File Source"
    "HP"    "DT_STR"    "0"    "0"    "14"    "1252"    "0"    ""    "Flat File Source"
    "Remark"    "DT_STR"    "0"    "0"    "19"    "1252"    "0"    ""    "Flat File Source"
    "Background"    "DT_STR"    "0"    "0"    "255"    "1252"    "0"    ""    "Flat File Source"
    "Photo"    "DT_STR"    "0"    "0"    "255"    "1252"    "0"    ""    "Flat File Source"
    "Signature"    "DT_STR"    "0"    "0"    "255"    "1252"    "0"    ""    "Flat File Source"
    "CreationTimeStamp"    "DT_DATE"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "ModifiedTimeStamp"    "DT_DBDATE"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "Folder"    "DT_STR"    "0"    "0"    "255"    "1252"    "0"    ""    "Flat File Source"
    "InstXID"    "DT_I1"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "AutoDebitAccountNo"    "DT_STR"    "0"    "0"    "255"    "1252"    "0"    ""    "Flat File Source"
    "OverridePresentmentTime"    "DT_STR"    "0"    "0"    "255"    "1252"    "0"    ""    "Flat File Source"
    "OverridePresentmentCycleParam"    "DT_I1"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "OverridePaymentTime"    "DT_STR"    "0"    "0"    "255"    "1252"    "0"    ""    "Flat File Source"
    "OverridePaymentCycleParam"    "DT_I1"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "PresentmentTimeStamp"    "DT_DBTIMESTAMP"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "PaymentTimeStamp"    "DT_DBTIMESTAMP"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "AutoDebit"    "DT_I1"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "OverridePresentment"    "DT_I1"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "OverridePayment"    "DT_I1"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "MemberStatusXID"    "DT_I1"    "0"    "0"    "0"    "0"    "0"    ""    "Flat File Source"
    "CIF"    "DT_STR"    "0"    "0"    "255"    "1252"    "0"    ""    "Flat File Source"
    "MotherName"    "DT_STR"    "0"    "0"    "40"    "1252"    "0"    ""    "Flat File Source"