I am relatively new to SSIS packages Package is a File system task to rename and move a file. Package runs correctly from SSIS store but whe I run it as asql server agent job it doesnt move or rename file but shows successful. What am I doing wrong
Asked
Active
Viewed 120 times
1 Answers
0
When executing the package from the store, you are likely executing the package under your own domain credentials, which probably have permissions on the folders/files impacted by the package.
When executing from the server agent, it likely does not have those same permissions on the files/folders. That would be the first thing I would check, but having additional information as to the resources being manipulated and user accounts used could potentially shed more light on the situation.

Kritner
- 13,557
- 10
- 46
- 72
-
Overthinking...thanks you answer was enough to get me on the right track – Joe Munch Sep 16 '20 at 20:35