Sep 18, 2014 at 9:02 PM
Edited Sep 18, 2014 at 9:59 PM
I am having some problems using the RegExFileFilter. I am using the 2008 version of TaskUnZip (couldn't get the 2012 version to load with SQL 2008 R2). I am using variables that are declared with a scope of package. I have those variables in a "Watch"
on VS 2012 and they are loading correctly with the values (from a SQL stored procedure). I am using expressions to load the TaskUnZip for FolderSource, FolderDestination, and RegExFileFilter. I have "Delay Validation" set to True because the values
for the expressions have to be loaded dynamically.
I have the FolderSource and FolderDestination set to:
. I have tried it as a setting in the property and as an expression setting thatsame property value. I have "RecurseSubFolder" set to False as I only want files that match the RegExFileFilter. Your "documentation"
mentions that the RegExFileFilter follows the .NET version. I have it set to @[User::FileName] + "." This should return all, and only, files that match the entire filename, but have different extensions. "TypeOperation" is set to "Compress".
During runtime, the RegExFileFilter shows .
which is what it would be set to before the variables load. That nevers changes. I set a breakpoint on every event allowed by VS2012 for TaskUnZip and stepped through them all. I put the TaskUnZip in the watch
list, but the RegExFileFilter, FolderSource, and FolderDestination are not available to view under it. All of my variables are and they all show the proper value.
The Output during runtime shows the following:
Information: 0x1 at TaskUnZip, UnZip SSIS: Start 1
Information: 0x1 at TaskUnZip, UnZip SSIS: Start process file: 'C:\temp\HIP\AL245.zip'.
Error: 0xC0024104 at TaskUnZip: The Execute method on the task returned error code 0x80070020 (The process cannot access the file 'C:\temp\HIP\AL245.zip' because it is being used by another process.). The Execute method must succeed, and indicate the result
using an "out" parameter.
Task failed: TaskUnZip
The zip file is being newly created and no other programs have it open or even the directory open. The zip file is actually valid with the correct files in it, but the task is failing with that error. I tried this with all breakpoints removed and get the same
So, what am I missing?