January 4, 2011 at 1:26 pm
Hi - quick help please - the help desk is clueless. A server that runs close to perfectly all the time is glitching today. Suddenly it doesn't recognize a drive letter (path) in an SSIS Package. It worked fine yesterday; nothing changed on the package. Thanks!
January 4, 2011 at 1:43 pm
Have you verified that the server still has that drive letter mapped properly? I would log on to the server and verify you can access this drive letter. If not there is your problem. If yes then perhaps try changing your SSIS to use a unc path instead of drive letter in you SSIS package. \\severname\drive$\folder
January 4, 2011 at 2:14 pm
Generally speaking I would consider it a best practice to use a UNC path when possible for exactly these reasons.
January 5, 2011 at 9:48 am
The problem is resolved. None of the obvious issues were present which is why I posed the question to this group. What resolved it was remoting in to the server and running the package manually from the server. A reboot was also performed so that may have solved the issue. Agree to using UNC and will most likely change that going forward as I did not create the package. Thanks again for responses.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply