Sorry if this isn't the right place for this but I got this problem dumped
on me, and I'm more of a mainframe guy. We have a package that each week
uses HTTPS to log onto a secure website and download 3 files. I then unzip
these files and run a SQL2000 DTS package which drops a bunch of tables,
recreates them and then uses Bulk Insert tasks to load them.

We are going to moving to SQL2005 and now I'm trying to deal with SSIS. I
was instructed to convert our DTS package to an SSIS project. I decided to
use the FTP task to get the data, until I learned the web site has no secure
ftp site so I have to use HTTPS. Here's were I stuck, is it possible first
of all, and which one of the bazillion tasks would I use to accomplish this?

Any and all help would be appreciated. I search the web and the online help
files and have still come up empty.


Bruce

Bruce,

Check out this blog:
http://blogs.conchango.com/jamiethom...5/31/4009.aspx

I used the sample package for a starting point on downloading a web
page. It was easy enough to modify. The object used to accomplish the
download is a script object.

Let me know if this helps. Good luck!

Jay


Bruce Martin wrote:

Jay,

I was able to use that package to download a file using HTTP. However I need
to get 3 zip files from a secure site that requires me to enter a userid and
password. I have nosed around in the help docs but can't seem to find a way
to send that information to the website.

Any ideas ?


Bruce


"Jay" <JasonPirtle (AT) gmail (DOT) com> wrote

Hey bruce,

You mentioned that you're converting this from a DTS 2000 package. How
did the DTS 2000 package get the files? If it was using a script, it
is possible to use scripts in SSIS.


Jay


Bruce Martin wrote:

Jay,

Sorry, when I said package, I meant another application, in this case
FreeDownManager. It does the automated HTTPS file transfer. I've searched
all over and haven't been able to find a way to the send the userid and
password to the website.

Bruce


"Jay" <JasonPirtle (AT) gmail (DOT) com> wrote