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
Expression to Format Dates to Two Digits

When you're creating a flat file, often times you'd like to place a date stamp at the end of the file name in order to show when the file was created simply when sharing the file with a partner. The problem comes in though where you wish to have a two digit date. If you were to create an expression...

Posted to Brian Knight (Weblog) by Brian Knight on 02-05-2008

Page 1 of 1 (2 items)

Pragmatic Works