text: Q:
  
  Why does SQL job choke on stored package?
  
  I've written a stored package to pull a text file into a table in the geodatabase.  It works perfectly.  However, when it is a step in a SQL job, the job fails at that step.  I'm looking for ideas on how to troubleshoot this issue.
  
  A:
  
  When I had an issue similar to this in the past, it was a permissions issue. When I set up the job, I had to tell SQL Agent to run the step with the package as a user with the correct permission level.  May be a place to start looking.
  
  