November 22, 2011 at 6:36 pm
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
November 25, 2011 at 4:50 am
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
November 25, 2011 at 5:07 am
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