Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

load zipped file to the table Expand / Collapse
Author
Message
Posted Wednesday, November 7, 2012 5:51 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, January 17, 2014 7:01 PM
Points: 91, Visits: 464
I have files which are saved in the web folder.and i get the file in the web folder every day which is in zipped format.Now i want to download the file from web folder which is in csv format and then unzip that file and load that to the table .The file comes with the date at the last (for e.g for today it is james_2012_11_07 and tomorrow it will be james_2012_11_08).Now, i want to create the package which should first download the .csv file then unzip that after that i want to upload that unzip file to the table ever day.How i can create that package?.
Post #1382220
Posted Thursday, November 8, 2012 12:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 13,562, Visits: 11,372
You can download the zip file using the Webservice Task.
You can unzip the file using the Execute Process Task which calls for example the Winzip.exe file.
You can load the .csv file to SQL Server using a data flow task with a flat file source.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1382306
Posted Saturday, November 10, 2012 8:26 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Sunday, September 14, 2014 3:17 PM
Points: 1,118, Visits: 2,224
If you can use third-party solutions, check the commercial COZYROC Zip Task. It is completely integrated in SSIS.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #1383414
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse