Download file with OLE DB Provider for Internet Publishing

From: Ryan Malone (ryanswebsite_at_hotmail.com)
Date: 05/28/04


Date: 27 May 2004 17:04:56 -0700

I have an issue where I need to automatically download files from our
partner's server that will be imported into a sql server 2000
database. I was hoping to accomplish the task using DTS to FTP but due
to the data being sensitive and our partner using IIS this is no
longer an option. I am now hoping to do it with dts using dts and OLE
DB Provider for Internet Publishing over https connection.

If anyone knows how to download a file to a local machine using dts
and OLE DB Provider for Internet Publishing I would really appreciate
the help.

Thank you
Ryan



Relevant Pages

  • Download file with OLE DB Provider for Internet Publishing
    ... I have an issue where I need to automatically download files from our ... partner's server that will be imported into a sql server 2000 ... I am now hoping to do it with dts using dts and OLE ... DB Provider for Internet Publishing over https connection. ...
    (microsoft.public.data.oledb)
  • Re: SQL 2000 - Connection Error with DTS Packages
    ... After I changed all SQL Server 'Database Connection' steps in each of my DTS ... Package" option when you right click a DTS package name in ME. ...
    (microsoft.public.sqlserver.dts)
  • Re: vb.net dataTbl can DTS read?
    ... then using ADO to read/write the data to Sql Server. ... like what DTS does with Text Files, MS Access data, etc. ... Right now I am experimenting with writing the data from ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server DTS From Sybase
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > DataPump is used interchangeably with the transform Data Task ergo not the> ExecuteSQL task ... >>>> I want to import data from a Sybase database via a SQL Server DTS ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Server DTS From Sybase
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > DataPump is used interchangeably with the transform Data Task ergo not the> ExecuteSQL task ... >>>> I want to import data from a Sybase database via a SQL Server DTS ...
    (microsoft.public.sqlserver)