I have a .dsv file and I need to import into sql database. I tried converting into text and csv file format but I am unable to import them properly.
The file is "|" delimited and it is unable to discover "|". Any help is highly appreciated.
Asked
Active
Viewed 1,467 times
0
Illuminati
- 555
- 2
- 7
- 34
-
In SS Data Tools 2012 you may specify delimiter for flat file connection in Flat file connection properties - Columns - Column Delimiter. Is there such options in SSDT 2008? – Aleksey Ratnikov Jul 13 '16 at 22:13
-
@zack are you using the import export wizard in SSMS? If you are, under columns there is a column delimiter drop down and you can change the delimiter to "Vertical Bar". – Arleigh Reyna Jul 13 '16 at 22:53