sqlinterset (12/18/2015)
When i am uploading data from flat file to sql server table... data is getting distributed to some other columns too..How this problem can be solved?
To actually see what you're seeing we need something to work with. Provide an example of the flat file (test data please, we don't need to see your company confidential stuff), the DDL for the target table and the command you use to load the data. What you expect and what you see would be useful too.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Give us the tools to look at your problem and somebody here will be able to take a look.