Post reply

How to find the properties of a flat file(.txt) when defining ssis connection manager

  • September 8, 2013 at 3:22 am

    #276954

    Please Advise!!

    I have to import data from a .txt file using SSIS package into sql server.

    HOW CAN WE FIND(KNOW) THE

    a) Format

    b) Text Qualifier

    c) Header row delimiter

    d) Row Delimiter

    e) Column Delimiter

    of .txt file when defining the "Flat File connection manager Editor in SSIS"

    Does SSIS autodetect these things when we select the file ??

  • September 9, 2013 at 9:55 am

    #1648594

    tinnusqlserver (9/8/2013)

    Please Advise!!

    I have to import data from a .txt file using SSIS package into sql server.

    HOW CAN WE FIND(KNOW) THE

    a) Format

    b) Text Qualifier

    c) Header row delimiter

    d) Row Delimiter

    e) Column Delimiter

    of .txt file when defining the "Flat File connection manager Editor in SSIS"

    ...

    Does SSIS autodetect these things when we select the file ??

    You need to supply the information based on the layout of the text file. It is not auto-detected.

  • September 9, 2013 at 12:27 pm

    #1648634

    You need to open the file and take a look yourself.

    Typically the analysis (if there is any) of your import should contain these details.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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