Help - this must be a security / authentication problem
Package runs fine in designer - but fails immediately when I
run via sql agent (It's deployed on the file system). The package
is super simple - just a truncate table, data flow import from Oracle
to sql server - and then a user stored procedure in sql server
View Job History in agent gives no help (step failed - great! why).
Any help anybody gives would be greatly appreciated.
BTW I'm the package owner and I'm in the sysadmin role in sql server.
I changed the account that runs sql and agent to be a domain account
and that account is also a sysadmin .
What have I forgotten ??