Calling "ssis" Experts

[SnehaLathaReddy]

Hi All,

I am new to SSIS(Sql server integration services). I need your help on below issue.
[color=#000000][font=Arial,]
I have to import data from a [b].txt[/b] file using SSIS package into sql server.[/font][/color][color=#000000][font=Arial,]
[b]HOW CAN WE FIND(KNOW) THE[/b][/font][/color][color=#000000][font=Arial,]
[b]a) Format[/b][/font][/color][color=#000000][font=Arial,]
[b] Text Qualifier[/b][/font][/color][color=#000000][font=Arial,]
[b]c) Header row delimiter[/b][/font][/color][color=#000000][font=Arial,]
[b]d) Row Delimiter[/b][/font][/color][color=#000000][font=Arial,]
[b]e) Column Delimiter[/b][/font][/color][color=#000000][font=Arial,]
of .txt file when defining the "Flat File connection manager Editor in SSIS"[/font][/color]
[color=#000000][font=Arial,]
[img]http://i.stack.imgur.com/gd1z5.png[/img][/font][/color]
[color=#000000][font=Arial,]
[img]http://i.stack.imgur.com/UcYiF.png[/img][/font][/color]
[color=#000000][font=Arial,]
[b]Does SSIS autodetect these things when we select the file using browse button??[/b][/font][/color]
[color=#000000][font=Arial,]
[b]Please advise!![/b][/font][/color]
[color=#000000][font=Arial,]
[b][img]http://www.desigifs.com/sites/default/files/2013/pfdb_brahmi001.gif?1377272460[/img] [/b][/font][/color]

[loveindia]

Default Values set avtai... You can also change according to you format..

CR LF ani options untai..
CR stands for carriage return.. antey enter is for next record..
LF stands for Linefeed..

[SnehaLathaReddy]

[quote name='loveindia' timestamp='1378673589' post='1304223032']
Default Values set avtai... You can also change according to you format..

CR LF ani options untai..
CR stands for carriage return.. antey enter is for next record..
LF stands for Linefeed..
[/quote]


Thanks india... so it will automatically detect the file properties while importing!! I have no intention to change default properties!!

[img]http://www.desigifs.com/sites/default/files/CS.gif?1370167246[/img]

[libraguy863]

yes depending on the source file, the delimiters are taken ,if you do not know the delimiters then we can use the ragged right feature defining your own delimiters

[sri_sql]

Usually while importing a text file through SSIS you will be provided specified delimiter an accordingly it would be tab most times.