Hi everybody. I want to insert data from text into sql server. Text file includes some words separated by commas. I want to copy them into only one colomn but when I try to use DTS it shows me too many colomns. How can I solve this problem? Thank you very much!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I want to insert data from text into database
- Thread starter mooniron
- Start date
DTS has many options for flat file text. Re-investigate the options for delimiters that DTS propmts you when specifiying the text file: you can choose "comma seperated" and if the file has no end of line separating rows, then choose to disable the end of line delimiter...
I think you will have to use another separator ( which tells to DTS there are more then one column, right now your data has many commas and DTS is trying to insert them into different column and you want to insert all of them into on column) in DTS to copy this comma delimated text into one column. You can use different delimaters in your DTS like ; or something else. I hope it helps you.
Muhammad Essa Mughal
Software Engineer
essamughal@yahoo.com
Muhammad Essa Mughal
Software Engineer
essamughal@yahoo.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
