package references - when loading to server storage
Posted on 2011-02-22
one of the package (in the visual studio solution) has reference to a text (.sql file) for some tsql code, in a task. we can run the package from visual studio. Now if I want to move it to the server storage (storing it in msdb),so that it can be called from a job, other than moving the dtsx file to the server (msdb), how should I update the reference for the misc text that is called/attached to tasks.