THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Jamie Thomson

This is the blog of Jamie Thomson, a freelance data mangler in London

Does SSIS in Denali solve the "relative paths" problem?

Earlier today I stumbled upon a blog post that I wrote back in 2008 entitled Absolute and relative paths where I said:

A common complaint about SSIS is that it does not allow the use of relative paths. The most useful application of this feature would be the ability to execute packages (using the Execute Package Task) where all the packages are (as is typical) stored in a single folder

I also pointed at a Connect submission I made requesting a solution to this problem which you can read at New [System::PackageLocation] variable please (54 votes and counting); someone at Microsoft replied in July 2010 with the following comment:

We believe that changes being made in an upcoming release will alleviate the concern you expressed; and therefore, we are closing this issue.

Fast forward 8 months to today and we now know that the change being spoken of is the ability to execute a package that is distributed in the same SSIS project (read more about this feature at The new Execute Package Task in SSIS in Denali). I'm in agreement with Microsoft - I think that this new feature does indeed solve this problem however I'm interested to know what other folks think. Do you have any scenarios in your current SSIS implementations that are not served by this new feature? Let me know in the comments.

@Jamiet

Published Friday, March 25, 2011 1:49 PM by jamiet

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Lee said:

Whatcha mean "relative paths" Jamie?  I used the following to 'relativize' my locations.  Is that a word now? :))

http://www.texastoo.com/post/2010/02/24/Relative-paths-in-SSIS-to-make-things-simpler.aspx

June 1, 2011 1:42 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement