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

    Question

  • 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 ??

    Sunday, September 08, 2013 9:10 AM

Answers

All replies