• This article came along at an opportune time as I was working on a DTS package that will be moved to production.  My only problem was with the diagram that showed the dynamic properties box directly connected to a connection object.  My version of DTS would not allow this.  I got an "Invalid precedence" error message.  I was able to make it work when I connected the task to the the first "Execute SQL" task.  I belive this has the same affect as the steps outlined in the article.