September 5, 2012 at 2:28 pm
How i can create a package to download file from website which is in zipped format then i have to load that file after unzipp to the table?. I have a website where every day new file come they just change the file name by changing the date in filename(like for today file name will be "center_2012_05_09.csv.gz" and tomorrow it will be "center_2012_06_09.csv.gz").I have to create a package which first should load the file in some folder then it should unzip that file and it should load that .csv(unzip) file to my table.How we can do that in ssis?.
September 6, 2012 at 2:29 am
Does the website have a webservice that you can use to download the file?
Or an FTP server?
If you need to download it over http:
Downloading a file over HTTP the SSIS way
You can use expressions to deal with the changing filename.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 6, 2012 at 2:59 am
September 6, 2012 at 11:50 am
yes,it has webservice.
September 6, 2012 at 1:43 pm
Can you use the webservice to get the file?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply