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: 259115

  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: 246986

  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.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel