File Properties Task v1.01 (SQL Server 2005)

Brian Knight — Sat, 03 Nov 2007 03:43:35 GMT

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. This download is a fully functional perpetual license and is distributed *as is*.

For more information about this task, please see http://www.pragmaticworks.com/filepropertiestask.htm.

Terminator Destination

Brian Knight — Thu, 06 Sep 2007 00:23:30 GMT

The Terminator Destination allows you to terminate a data flow into a dead end. It acts as a stub for other code that you may eventually write once you receive the business requirements. As it receives data, it simply disposes of the data and you can ideally put a data viewer on it to test.

This free SSIS component is supported through the forums only and is distributed *as is*.

SSIS Components

File Properties Task v1.01 (SQL Server 2005)

Terminator Destination