Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to find the properties of a flat file(.txt) when defining ssis connection manager Expand / Collapse
Author
Message
Posted Sunday, September 8, 2013 3:22 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 12, 2013 9:58 AM
Points: 39, Visits: 230
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 ??
Post #1492584
Posted Monday, September 9, 2013 9:55 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, September 11, 2014 11:57 AM
Points: 504, Visits: 1,869
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.
Post #1492848
Posted Monday, September 9, 2013 12:27 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:05 PM
Points: 13,735, Visits: 10,704
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1492894
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse