created a package to check old files residing in one folder.the owner of the package is a windows account and have full rights to the folder.The windows user is denied permissions to sql server It runs fine when executing the package.When sheduled and ran the package it gives dtsrun.exe application error pop up message . It is logged in application log too Please guide me on this DBA SHAMS
check whether the service account have permision on that folder. can you plese paste the full error to the forum. ----------------------------------------
My suggestion... There may be lot of steps included in ur DTS, break it into different steps and then create the jobs having different steps. Most of the time, I resolved the problem by this way... Regards Ashsih Ashish
dts is not having any issue and it is running fine.It has only one activex script to check the old files DBA SHAMS
The job failed. The Job was invoked by Schedule 53 (Pkg_CheckGalUploadFiles). The last step to run was step 1 (Pkg_CheckGalUploadFiles). Executed as user: oslerhc sgadmin. The step did not generate any output. Process Exit Code 128. The step failed. DBA SHAMS
THen make sure the SQLAGent has required privileges on th specified directory that is executed on that Activex script. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.
