Just came across your article and fine it very useful tools for me to learn sqlis. I have a problem with Execute SQL Task in the loop container:

Insert into tmpTlogFileList(FileName)values(@FileName):

Execute SQL Task: Executing the query "insert into tmpTlogFileList (FileName) values (@FileName)" failed with the following error: "Must declare the scalar variable "@FileName".".

Must I declare @Filename as nvarchar(128) from the sql statement?

thanks