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
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.