|
Hi, When i run the package from SSMS, the data is loaded into the corresponding tables BUT when i run the same package using sql job, the job executes without any errors but the data is not loaded. What Could be the reason ? FYI: I'm using SqlServer 2008 in Windows Server 2008, the VMWARE is running on 64 bit machine. Thanks, sqlhungry
(comments are locked)
|
|
What is the package doing? There is a log somewhere, either the SQL Agent Log or the SQL Server Log that will have details about any error. By chance are you working with Excel in the package?
(comments are locked)
|
|
Yes @KenJ is right - this sounds more like an issue with the execution account of the job, which can either be set in the job, or will be run under the account running the SQL Agent Service. This is the difference between running it in SSMS and as a job. Being on VMware will have nothing to do with it.
(comments are locked)
|
|
As you guys suggested, I am debugging the access right and privledges issues. Thankyou.
(comments are locked)
|
Are there any messages in the package execution log or sql logs?
This type of behavior is often caused by the SQL Service/Agent account not having access to the resources that your user account has (files, mapped drives, other sql servers, etc).