Quick thought, add error handling in the exe code with specific error numbers, then you at least will have a chance of knowing what is going wrong.
😎
Thank you for your reply. I will try to add error handling to the c# code. I think it may be some access issue so the exe only runs half way. I will post my find out.
Kevin
When you run the package, you probably do so within Visual Studio, and you get your id as the execution context. When you run the package as a job step in a SQL Agent job, the id that is used for the SQL Server Agent service is used instead, and IT must have the necessary file permissions to access the executable file as well as the data file source and destination folder locations.
To follow up on this, the default account used for SQL Agent jobs is a SQL-only login, so it will not have rights to your file system.
John
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA