Exporting data from excel to sql server 2005

• hussain.zoheb

  Newbie

  Points: 3

  More actions

  January 22, 2009 at 12:04 am

  #204406

  Hi All,

  Please help me with my below query.

  Scenario: User wants to upload data from an excel to the sql server 2005.

  (The excel contains information about the employees)

  The excel might contain about 5000 records which user wans to upload.

  Also what he wants is if there is any error in any of the records then those records should not be inserted in the database and the rest to be inserted.

  Also he should get a notification of the records that failed to upload with the reason.

  Please let me know how i can achieve this.

  I guess SSIS should do the job. But again i have no idea how this (SSIS) works.

  So please advise.

  TIA

• wissemhabboub

  Mr or Mrs. 500

  Points: 558

  More actions

  January 22, 2009 at 9:35 am

  #931274

  you can resolve problem of invalid records by using error path of your SSIS component (Red line of component).

  Try this link :

  http://msdn.microsoft.com/en-us/library/cc304392.aspx

  "Lesson 3: Handling Data Flow Errors and Debugging"