Change SSIS package location (REPOST from SO) My SSIS Package are located in shared drive with a long path name. To make the packages easier and not to remember long path name, I use "Map my network drive" option and use X: drive as an alias to access packages. Next thing I know that all my packages locations have been updated as "X:\Package5.dtsx". Now if the pseudo network drive is disconnect, I cannot access the packages (outside the server).

Please find the snapshot that will justify what I actually meant.



How can I change the package name from X:\ to actual share drive name (where my package are stored)? I don't want to do some changes that could effect how this package run since they are very critical to the business continuity
Can you point the 'full path' to the UNC path i.e. \\&lt;servername&gt;\&lt;sharename&gt;\&lt;directoryname&gt;\&lt;packagename&gt; instead and see if that works?

Just like when you map the "X" drive to \\&lt;servername&gt;\&lt;sharename&gt; just use that in the full path of one of your packages and run to see if it'll work. 

If one of your jobs work like that (assuming most all are setup the same and this way, etc), you can probably script out the SQL Agent jobs through SSMS by pressing F7 (once SQL Agent jobs is highlighted), selecting them all from the right pane window, right click, then create to new query window, then do a mass CTRL+H and do a find and replace to replace X:\ with \\&lt;servername&gt;\&lt;sharename&gt;, and then run that.

Just be sure the SSIS proxy account or the SQL Server Agent account has appropriate NTFS and SHARE permissions where the SSIS packages reside to read them.