SQL Server Performance

Uploading CSV File

Discussion in 'SQL Server 2008 General Developer Questions' started by sqldev, Jun 16, 2009.

  1. sqldev New Member

    I want to upload the CSV File data into a table. It can be done using SSIS. I would like to know the other options available to do the same.
    In Oracle, we have SQL*Loader available to do the basic data transformation, likewise, what are the utilities available in SQL Server 2008, thank you.
    SQL Dev
  2. FrankKalis Moderator

    You can use OPENDATASOURCE, OPENROWSET, BCP, or BULK INSERT. But in many cases an SSIS package is more convenient.

Share This Page