Solved

0KB file when downloading with SSIS VB script from SharePoint

Posted on 2016-10-18
2
46 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
2 Comments
 
LVL 14

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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

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 …
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now