Jenny,

Look at this package. All you need to do is change your database connection,variables and its expression.

1. change connection to your database

2. change variables values : SourcePath,Dstpath and FileName(File...

PD

your advice is awesome.I can get rid of dummy file. Thank you . thank you.

AM

when you look at my package, you see that it skips the dummy file if checkdummy is false. if you use script task or archive file to move your file...

hope attached example will help you a little.

So i think maybe the foreach loop only works for Excel files when there are multiple files in the same folder?

NOT true.

For my case, I have to do Data conversion...

Jenny,

I followed the tutorial of this link. It works for me.

http://bi-polar23.blogspot.com/2007/08/loading-multiple-excel-files-with-ssis.html

I believe so.I have to find another solution. Thanks.:unsure:

I do not use script task. I found a workaround that I have to put a dummy excel file which has a header row with no data in the folder....

Jenny,

I am having the same problem with SSIS. I am trying to load whatever excel files from the folder. The excel file names will be changed all time.Did you find...