I currently do a package conversion, which is to import the data in an excel table into the server database. Manual execution of the package can be executed, but when it is scheduled, it cannot be executed when the package is executed in the job, please master help!!!
See if your Excel is on a network drive or a local hard drive.
Then look at your SQL Server Agent service account. Does this service account have permission to access your Excel files and SQL Server?
When you run it manually, the execution of DTS will refer to the account permissions you use to log in to Windows, but if you use scheduled execution, look at the permissions of the service account you use.
Executed in the query analyzer (whether the execution was successful with a stored procedure). If it can be executed.
Then check your JOB configuration ..
|
|
China
Post time: 2020-1-4 07:50:01
