Import data from a fixed width file into sql table using sql server 2000.

Posted by Mahendrabasutkar under Sql Server on 6/3/2011 | Points: 10 | Views : 4370 | Status : [Member] | Replies : 3
How to import data from a fixed width file into sql table using sql server 2000.




Responses

Posted by: A4u6178 on: 6/3/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

will u pls elaborate what does fixed width file mean ??? is it csv file or something else??

Thanks & Regards;
aaa

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Mahendrabasutkar on: 6/3/2011 [Member] Starter | Points: 25

Up
0
Down
'Fixed width file' is one of format of file, wherein each column length is fixed.
If column data exceeds the given length them excess data is truncated,
If column data is smallar than the given length them white space is occupied.

Thanks & Regards
mhendrabasutkar

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: A4u6178 on: 6/3/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,


refer the below link.
http://www.bigresource.com/MS_SQL-Large-Fixed-width-Text-files-using-SSIS-SmGYW44W.html

Thanks & Regards;
aaa

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response