Archive for December, 2007

December 25, 2007 5

Parsing Ftp.ListDirectoryDetails and ListDirectory

By in Uncategorized

I just started a project which requires a FTP client that will download a root directory recursively. This means simply that a user can specify a single directory, and this client needs to download all the files in that directory, and traverse through all subdirectories and grab those files too. To traverse through subdirectories, you [...]

December 21, 2007 0

Recreating Production Environments for Integration and Staging

By in Uncategorized

Fileserver: dir /s /b \*. > dirstructure.txt lists fullpaths to each directory

December 17, 2007 0

SSIS Expressions are great

By in SSIS

Previously I posted about how to obtain relative picture paths from your database, flip the direction of the “slashes” and delete the image using a ‘Filesystem Task.’ I posted a stored procedure that does a ‘replace’ on forward slashes with backslashes, and I don’t think that is the best way to do it. The database [...]

December 16, 2007 0

Simple Fluid/Liquid Layout in CSS

By in Fun

I’m always frustrated with CSS, not because of syntax or construction… but the inconsistencies of rendering engines. Fluidity is important to me, my page should have the same look no matter how you resize your browser window. Creating fluid/liquid layouts isn’t as hard as I thought it would be. Step 1: Draw a general layout [...]

December 13, 2007 0

Deleting Files with SSIS

By in SSIS

A common practice is to have user’s upload images to a directory that is readable from IIS, store that upload path to a database, and then construct a relative path to that upload directory for use within your web application. What happens if that data has to be removed? Example Scenario: You are running your [...]