Solved

0KB file when downloading with SSIS VB script from SharePoint

Posted on 2016-10-18
2
80 Views
Last Modified: 2016-10-26
Hello

I have a VB script that uses the HTTP connection manager of SSIS to download a specific file from a sharepoint url.

The problem I'm getting is that the file is created, but with no content (0KB).

I can connect and download the file when using the web browser, but can't even connect to the same URL when using the HTTP connection manager.

Anyone with ideas with this?
0
Comment
Question by:barkome
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
Megan Brooks earned 500 total points
ID: 41859676
My impression has been that about the only thing you can directly use an HTTP connection manager for is to obtain the connection string. I was surprised that you were able to obtain even an empty file, though, and with a bit of Googling I came across this blog post (skip down to the 2nd example). Is there anything in there that helps?


Here is the stackoverflow question that led me to the above post: How to make an HTTP request from SSIS?
0
 

Author Closing Comment

by:barkome
ID: 41860574
Eventually used the C# script to get it to work
1

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

From time to time, for debugging and troubleshooting your flow at run time you’ll need to check if the variable has the correct value or not, there’re several ways to check for the value of the variables inside the flow, You can add Break Points, a …
My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question