Post reply

Can we load csv file using BULK option with OPENROWSET

  • May 17, 2012 at 12:17 am

    #261156

    Hi All,

    I need some recommendations on

    How to load csv file using BULK option with OPENROWSET, Please Let me know

    Thanks,

    BB

  • May 17, 2012 at 2:18 am

    #1488829

    BeginnerBachi (5/17/2012)

    Hi All,

    I need some recommendations on

    How to load csv file using BULK option with OPENROWSET, Please Let me know

    Thanks,

    BB

    have a look at this article recently posted

    http://www.simple-talk.com/sql/t-sql-programming/the-tsql-of-csv-comma-delimited-of-errors/

    i would recommend OPENROWSET - as does the author of the article

    MVDBA

  • May 18, 2012 at 1:38 am

    #1489502

    You may also consider a SSIS solution using Bulk Insert Task

    Raunak J

  • May 18, 2012 at 8:27 am

    #1489719

    I agree that an SSIS solution would typically be the best solution for transferring data to a CSV file. It tends to be more easily modified/debugged down the road.

    James

  • May 18, 2012 at 8:30 am

    #1489721

    james.ciesla (5/18/2012)

    I agree that an SSIS solution would typically be the best solution for transferring data to a CSV file. It tends to be more easily modified/debugged down the road.

    James

    i think it's the other way round - the data is transferred from a CSV file

    MVDBA

  • May 18, 2012 at 8:46 am

    #1489733

    Thanks for clarifying Mike, I thought he was trying to extract data into a CSV file.

    I still think SSIS would be a good choice if the CSV file comes in a consistent format.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply