none
(Sumber: milis SQL Server) Remove delimeter "," pd saat bulk insert RRS feed

  • Pertanyaan

  • Temans,

    saya ada data csv ±200ribu row data. setiap pagi jam10 menggunakan bulk insert memasukkan data tsb kedalam tabel, masalahnya ketika mapping column by column, data yg masuk ke tabel beserta dengan delimeternya ("). Naah gmana cara menghilangkan delimeter tsb ketika sudah masuk kedalam tabel pd saat bulk insert tsb?
    Contoh data :
    No. | nama. | dob. |
    "001","fajar","1985-08-22"
    "002","ryan","1960-06-08"
    "003","harli","1980-11-09"

    Kira2 kueri insertnya spt ini,
    BULK INSERT mytabel from 'csv_file_source'

    Ga pake tambahan tabel dan tambahan proses utk update row/row yaaa.




    Agnes Sannie [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Kamis, 26 Juli 2012 07.10
    Moderator

Jawaban