question

sqlhungry avatar image
sqlhungry asked

data not loaded from sql job in vmware

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
sqljobvmware
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
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).
1 Like 1 ·

3 Answers

·
Kev Riley avatar image
Kev Riley answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image
Tim answered
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?
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sqlhungry avatar image
sqlhungry answered
As you guys suggested, I am debugging the access right and privledges issues. Thankyou.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.