Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 107
  • Last Modified:

0KB file when downloading with SSIS VB script from SharePoint

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
barkome
Asked:
barkome
1 Solution
 
Megan BrooksSQL Server ConsultantCommented:
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
 
barkomeAuthor Commented:
Eventually used the C# script to get it to work
1

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now