by filename, if filename can be found in local drive, then do not download(loaded already before), if filename not found in local drive then download that file.

how about OpenRead method? Does it work?

I think Regex may also accomplish this; has anyone used Regex in VB.Net? thx

Hi I'm doing the same thing, download file from https. the webconnection part works but the downloadfile part doesn't.

With WebConnection

.DownloadFile("http://www.site.com", "file.zip")

is file.zip the...

Thanks! I hope so, but can't, busy with new ssis proj again. You'll see more questions posted by me. For new ETLs we'll use SSIS, all our old ETLs we...

ayemya, Thanks so much for your continued help!! Just one change made it work.

The most import part which you mentioned and which I missed is to change the DelayValidation...

PD, Even if I in the properties of Excel Connection Manager 2 I changed from connectionstring to excel file path and used the variable FileWeJustFound it doesn't work. I tried...

I only want the enumerator to process only one file each week when the package runs. And yes I did set the DelayValidation to True.

And you can't delete the expression...

you have three files including the dummy one. Are they all in the same folder at the time when you execute the foreach loop container?

For my case I only...

yes they have the same header since there is only one file. I changed the filename for testing, because in reality we only have one file in that folder each...

Phil, I followed exactly the steps in the link provided by ayemya and it worked up until step 18, after the foreach loop step is set up, and once I...

Phil, yes I put the whole thing: directory, filename and extension (.xls) in the excel file path. I'll look at the link which worked for ayemya, and if it still...

Hi ayemya, can you describe the steps you did. I tried but still no luck.

I would get error running the foreach loop container if I put the dummy file path...

That might be the solution, let me try that, mine didn't work because my dummy excel file doesn't have a header row. I have to use col1, col2, etc, I...

Nope, I tried tons of times but it still didn't work, tried Jim's way (he says works for him) still no success; even tried script task using the code (below)...