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.
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.