Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hismightiness
Posting Yak Master
164 Posts |
 Posted - 2008-04-08 : 09:27:07
|
| Is there a way through SSIS to import a file from the Internet instead of a local file?http://www.domain.com/files/filename.csvI would like to be able to do this. If it is not possible, what is a good practice for doing this?- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-08 : 09:51:32
|
download the file to the server and import it from there.EDIT: might want to download it to a client machine first and scan it for bugs 
elsasoft.org |
 |
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2008-04-08 : 10:50:12
|
| I want to be able to automate the download the file. I am already doing this in my application through a scheduler mechanism, but I also wanted to gauge how others are doing this.- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-04-08 : 13:52:02
|
| This link says you can with an HTTP connection, however, I never tried it:http://technet.microsoft.com/en-us/library/ms137602.aspxFrom TechNet:An HTTP connection enables a package to access a Web server by using HTTP to send or receive files.How to create an HTTP connection:Right click on the Connection Manager area and choose the HTTP Connection Manager Type.How to use?No idea. |
|
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2008-04-08 : 13:57:37
|
| I guess this will do it.http://sqlblogcasts.com/blogs/greenmtnsun/archive/2007/09/06/http-authenticatoin-download-of-file-in-ssis-to-csv-file.aspx |
|
|
|
hismightiness
Posting Yak Master
164 Posts |
Posted - 2008-04-08 : 20:26:27
|
| What a great link. Thanks!- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
|
|
|
|
Import File from Web?