SQL Agent Logon - What is going on?
- by James Wiseman
I have a DTSX package that is called from a SQL Agent Job.
The DTSX package references a file at a fixed location (e.g. e:\mssql\myfile.txt).
On most machines, this location exists, but on some I have to manually map this (which is not a problem - I know a better solution would be to use package conifgurations to dynamically pull the file…