Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 3953
Home > Forums > Sql Server >

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 : 5648 | Status : [Member] | Replies : 3
Write New Post | Search Forums | AnsweredResolved Posts | Un Answered Posts | Forums Home 
How to import data from a fixed width file into sql table using sql server 2000.



Reply | Reply with Attachment
Alert Moderator 

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

Latest Posts