need help with bulk copy In SSIS.

• sql.kishore1

  SSC-Addicted

  Points: 435

  More actions

  August 19, 2010 at 9:03 pm

  #228100

  Hi folks.

  i had hardtime while transfering data from an excel file to Sql Table using Bulk copy command. i wrote the Script in script task of ssis package.

  How to do mapping between Excel file and sql table attributes.A sample code Will help me a lot.

  Thanks

  Kishore battula.

• Koen Verbeeck

  SSC Guru

  Points: 259015

  More actions

  August 20, 2010 at 12:26 am

  #1209472

  Hi.

  Why don't you use an Excel Source and an OLE DB Destination to accomplish this?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP