?
Solved

0KB file when downloading with SSIS VB script from SharePoint

Posted on 2016-10-18
2
Medium Priority
?
122 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 16

Accepted Solution

by:
Megan Brooks earned 2000 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…

589 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