Browse by Tags

Detecting if a File is in Use in a SSIS Script Task

When mainframes or partners are uploading a file, you don't want to process the file until you're certain the file is fully uploaded. One way to do this is with a Script Task in SSIS. There is no magic property to determine in the operating system to see if the file is in use though so you'll...

Posted to Brian Knight (Weblog) by Brian Knight on 10-15-2008
File Properties Task Now Free

File Properties Task 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...

Posted to Brian Knight (Weblog) by Brian Knight on 03-17-2008
File Properties Task v1.01 (SQL Server 2005)

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...

Posted to SSIS Components (FileGallery) by Brian Knight on 11-02-2007

Page 1 of 1 (3 items)

Pragmatic Works