Import excel files from sharepoint to sharefolder.

• sabarichandru

  SSCommitted

  Points: 1704

  More actions

  November 22, 2011 at 6:36 pm

  #248335

  Hi Folks,

  I have a requirement to import the excel files from sharepoint site to share folder using SSIS. when i rerun the package it should overwrite the existing package in the share folder.

  can anybody help me out by sending the step by step examples to finish this task .. it's very urgent today i have to finish it up.

  Regards,

  Sabarinathan.C

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  November 25, 2011 at 4:50 am

  #1412955

  You can download a file using the HTTP Connection Manager:

  http://www.sqlis.com/sqlis/post/Downloading-a-file-over-HTTP-the-SSIS-way.aspx

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

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  November 25, 2011 at 5:07 am

  #1412961

  I remember now why I didn't respond to this post originally. This sentence:

  when i rerun the package it should overwrite the existing package in the share folder.

  worried me - the package should overwrite itself.

  ---