| Groups | Blog | Home |
sql server dts : Using an SSIS Package to HTTPS a File
Check out this blog: http://blogs.conchango.com/jamiethomson/archive/2006/05/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 [quoted text, click to view] Bruce Martin wrote:
> 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
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
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 [quoted text, click to view] "Jay" <JasonPirtle@gmail.com> wrote in message news:1164736306.447563.113420@h54g2000cwb.googlegroups.com... > Bruce, > > Check out this blog: > http://blogs.conchango.com/jamiethomson/archive/2006/05/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: >> 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 >
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 [quoted text, click to view] 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@gmail.com> wrote in message > news:1164736306.447563.113420@h54g2000cwb.googlegroups.com... > > Bruce, > > > > Check out this blog: > > http://blogs.conchango.com/jamiethomson/archive/2006/05/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: > >> 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 > >
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 [quoted text, click to view] "Jay" <JasonPirtle@gmail.com> wrote in message news:1165007014.457166.292030@79g2000cws.googlegroups.com... > 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, >> >> 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@gmail.com> wrote in message >> news:1164736306.447563.113420@h54g2000cwb.googlegroups.com... >> > Bruce, >> > >> > Check out this blog: >> > http://blogs.conchango.com/jamiethomson/archive/2006/05/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: >> >> 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 >> > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |