Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vswvsw
Starting Member
13 Posts |
 Posted - 2011-07-06 : 08:11:27
|
| i am using SQL 2005.I am importing a flatfile copied from an excel source to sql2005Even though i mention text qualifiers as none,when i load to table i am getting some fields along with the text qualifiers"xxxx".I need to remove this...any solution |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-07-06 : 08:19:42
|
| Are the text qualifiers in the flat file you are loading?If you specify none then these will be considered part of the value and be included - and also the load could fail if a separator is included in the column.It sounds like you should specify " as the qualifier.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
vswvsw
Starting Member
13 Posts |
Posted - 2011-07-06 : 08:26:41
|
| YES IT IS THERE in the flat file i am loading. I will try the way you said... |
|
|
|
vswvsw
Starting Member
13 Posts |
Posted - 2011-07-06 : 08:38:34
|
| yes its working.........thank you so much..... |
|
|
|
|
|
|
DTS package