A common issue that I run across with clients is they want only want to process a file if it's finished transmitting to the server. This SQL Server 2005 task reads the properties of a file and writes the values to a series of variables. For example, you can use this task to determine if the file is in use (still be uploaded or written to) and then conditionally run the Data Flow task to load the file if it's not being used. You can also use it to determine when the file was created in order to determine if it must be archived. http://www.pragmaticworks.com/filepropertiestask.htm

Future readers note that this is not free, though a trial is available.

It works in a computer with 32 bit but does not work with 64 bit, it fails during installation. There is any kind of solution?

I've just created a Task that will allow you to read (and write) multiple properties (dates and attributes) of files: File Properties Task. It should work in 32-bit or 64-bit environments of SSIS 2005 or 2008.

Todd- i'm running into a strange problem with your very helpful File Properties Task- it runs fine in Visual studio using production data sources, and ran fine for a couple of days when I deployed into production, but all of a sudden stopped working in production with the following error: Message Executed as user: [a domain admin user]. Microsoft (R) SQL Server Execute Package Utility Version 10.0.3798.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 4:41:59 PM Error: 2011-05-02 16:41:59.53 Code: 0xC0010018 Source: File Properties Task Description: Failed to load task "File Properties Task", type "ToddMcDermid.SSIS.FilePropertiesTask, FilePropertiesTask100, Version=1.0.0.0, Culture=neutral, PublicKeyToken=6c005605b216cf47". The contact information for this task is "Todd McDermid". End Error Error: 2011-05-02 16:41:59.56 Code: 0xC0010026 Source: File Properties Task Description: The task has failed to load. The contact information for this task is "Todd McDermid". End Error Error: 2011-05-02 16:41:59.56 Code: 0xC0024107 Source: File Properties Task Description: There were errors during task validation. End Error Error: 2011-05-02 16:41:59.56 Code: 0xC0010025 Source: Package Description: The package cannot execute because it contains tasks that failed to load. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:41:59 PM Finished: 4:41:59 PM Elapsed: 0.313 seconds. The package execution failed. The step failed. I've since re-run it in development with no problems, re-saved it to the production server, but am getting the same error, and its a validation error on the task, not a runtime error. the only other thing i can think to do is re-install the task, but if its running in development....any ideas what might be wrong? thanks!

That's the only thing that I can think of - it appears as though the task itself, or some dependencies have been uninstalled. To check to see if the task is installed, ensure the FilePropertiesTask DLL is in C:\Windows\Assembly as well as the C:\Program Files\Microsoft SQL Server\100\Binn\DTS\Tasks folders... Talk to me now on