Solved

0KB file when downloading with SSIS VB script from SharePoint

Posted on 2016-10-18
2
65 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 15

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

751 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