1
Vote

File Properties Task set up issue

description

Let me re-explain. A task that has been assigned to me is cleanup. Our drives have tones of old files on them.
 

 
I know I can read files down threw the sub-directories (there are 1000’s) I can get the path and file names.
 

 
But I want to address the large files first. SO these are the steps I have taken.
 

 
1) went to http://filepropertiestask.codeplex.com/ and down loaded this
 
2) right click on toolbar
 
3) choose Items
 
4) SSIS control flow items (tab)
 
5) Pick File Property Task
 
6) Close and open bids and wala it works
 
7) On my non-company laptop this works
 
a) ForEach Container
 
b) Pass to the new File Property Task
 
c) Insert into Big_file_Names (FIleName,filepath,filesize,fdate,accessdate,.etc.etc.)
 
Values(@Filename,@Filepath,@Filesize,etc,etc,,,,,)
 

 
               This works on my laptop. I build a table with all the information I need. 
 

 

 
But on the company system. I installed on my pc and it doesn’t work. I installed on the server remote into it and it doesn’t work.
 

 
So I was wondering if you have another way. But I see in your last email. The link to script code. I might have to use and adjust.
 

 
The File Properties Task has all the information in it I need. I just cannot get it to work on the machine I need it on.
 
 
 

 
 
 

 
Error in the output view
 
SSIS package "List_Metadata.dtsx" starting.
 
Error: 0x0 at File Properties Task, File Properties Task: Unable to retrieve variable information: Value does not fall within the expected range.
 
Information: 0x0 at File Properties Task, File Properties Task: File '\Phivmfile001\DS\Production\Development\ftpcmd.txt' exists.
 
Warning: 0x80019002 at File Properties Task: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
 
Task failed: File Properties Task
 
Warning: 0x80019002 at Check Directory: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
 
Warning: 0x80019002 at List_Metadata: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
 
SSIS package "List_Metadata.dtsx" finished: Failure.
 

 
Mark

file attachments

comments

toddmcdermid wrote Jul 22, 2010 at 6:55 PM

The initial error message reported by the component ("unable to retrieve variable information") is due to one of your passed in variables not being accessible to the component. Why this would be different in production is unclear to me. You wouldn't be using that same variable in a concurrently running task, would you? Have you serialized all the Tasks within your Foreach Loop Container?

wrote Feb 14, 2013 at 2:15 AM