Archive for the ‘SSIS’ Category

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

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