Post reply

Bulk insert task Question

  • June 28, 2011 at 9:00 am

    #240682

    I have around 1 lakh data stored in Excel.

    Is it possible to insert this data in to SQL SERVER using Bulk Insert Task?

  • June 28, 2011 at 10:36 am

    #1345328

    Hi praveensc2003,

    Am I right to assume by 1 lakh you mean 1 million rows?

    If so, the answer is yes, SSIS should be able to easily handle this using an Excel Source in a Data Flow task.

    You'll just have to map your column names and which table you want to send the data to.

    Hope this helps.

    Cheers,

    Jim.

    SQL SERVER Central Forum Etiquette[/url]

  • June 28, 2011 at 10:51 am

    #1345345

    praveensc2003 (6/28/2011)

    I have around 1 lakh data stored in Excel.

    Is it possible to insert this data in to SQL SERVER using Bulk Insert Task?

    To clarify, no, you will not be able to use the Bulk Insert Task. The Bulk Insert Task is for inserting data from a File or Flat File connection only. To import data from an Excel file you'll have to use a Data Flow Task with an Excel Source and one of the various database destination options (e.g. OLE DB Destination, SQL Server Destination, ADO.NET Destination (2008)).

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • June 28, 2011 at 11:54 am

    #1345397

    Thanks for the clarification

Viewing 4 posts - 1 through 3 (of 3 total)

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