Hello,

I have created a package that loops through multiple folders and inserts
(the file path and name) of any new files within these folders into a
tracking table. When I run this package manually through BIDS it works
correctly. This package needs to be run every morning so I created a SQL
Server Agent Job that runs dtexec.exe /file “<path>\package.dtsx” in the
command line. When I run this, it completes successfully but doesn’t run the
Execute SQL task which calls a stored procedure to insert data into the
tracking table.

I have another package that is almost exactly the same as the above package,
except for a different file type, which successfully completes the whole
process when ran using the dtsexec utility. I have compared these two
packages and each task appears to be exactly the same, so I’m not sure if it
is a particular task or the dtexec utility that is causing the problems.

I hope this makes sense and any help would be greatly appreciated.

Thank you,