Import excel files from sharepoint to sharefolder.

  • 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

  • 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

  • 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
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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