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 should have the least amount of work to do period. Expressions are a way to evaluate and calculate certain values on the fly. That being said, use expressions.
Example Scenario: You have a stored proc that returns a result set of relative paths (i.e. /images/yourface.jpg”). You want to turn that path into the full UNC path.
Step 1: Create a variable to store the returned path
- In the variables pane click Add Variable (call it ReturnedPath) as a String
- Create an other variable called BaseDir as a String and hard code the value for your base directory (i.e. \\fileserver\uploads)
- Create an other variable called FullPath as a String
Step 2: Create an expression for the FullPath variable
- Click on the variable FullPath and select EvaluateAsExpression to True
- Click and expand the Expression Property
- Expression should be: @[User::BaseDir] + REPLACE( @[User::ReturnedPath] ,”/”, “\\” )
What this does: It takes the hard coded value of BaseDir and concatenates the ReturnedPath with the forward slashes replaced with backslashes
