Sample Header Ad - 728x90

SSIS package not copying files when run from SQL Server Agent

0 votes
1 answer
160 views
I have a simple SSIS package that copies files from one directory to another and then deletes the source file. It works fine when run from Visual Studio. Although when I add the package to the SSIS catalog and schedule it via a SQL Server Agent job the files do not get copied over. The job history is showing no authentication errors, so I have no idea what the issue is. Any advice would be appreciated package connection confg enter image description here
Asked by Jeff Shumaker (1 rep)
Jul 31, 2024, 09:13 PM
Last activity: Jul 16, 2025, 05:05 AM