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 |
|
itmaster
Starting Member
28 Posts |
 Posted - 2015-04-03 : 13:37:47
|
| Hi,Someone was telling me that they had a text file that was both comma and piped delimited and that they used BCP to import it.While they did not remember the exact details, they said that first it converted it to XML and then used bcp to import it.Can someone explain how this is done; I cannot find anything on the web about it.Thank you |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-04-03 : 16:11:15
|
| If it were me, I'd go back to your "someone" to get more details. However this could be done with SSIS with a little work. |
 |
|
|
|
|
|
How to import a text file