Download and import multiple files from URLs

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.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Download and import multiple files from URLs

Author

Topic

NickStan
Starting Member

36 Posts

Posted - 2009-08-19 : 10:38:09

We are migrating from SQL 2000 to SQL 2008.

I now have to write my first SSIS (DTS) package in 2008.

I need to do the following:

-- Get 5 URLs from a table
-- Download the files created from the URLs
-- Unzip the files downloaded
-- Import the unzipped files into a table

All I really can do at the moment is import the unzipped files into a table

Any suggestions on how to do the others?

Thanks

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-08-19 : 16:15:44

1. Get 5 URLs from a table
Use the ForEach Loop to get the data out of a table/procedure

2. Download the files created from the URLs
Use the Execute Process Task to download the files
Have a look at CURL

3. Unzip the files downloaded
Use the Execute Process Task to unzip the files
You'll need a command line unzip utility. WinZip has one and there are several others.

This is a good site for anything SSIS related: http://www.sqlis.com/

Hope this helps

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources