We have one DTS package, and when we try to execute it, we get errors on some systems. Though the package used to be executing on those systems previously.
We are using windows authentication. All the users are in one AD group and that AD group is added as an user in the SQL server. So all the users have same level of access in SQL server. But suddenly we are getting issues while executing DTS package on few machines. It says - the DTS package encountered an error.
the DTS package uses some views and creates a flat file on one loaction. It then FTP that file to another location.Thanks, Alok
Do I understand you correctly that this same DTS is being ran on multiple servers? If so is SQL Agent launching with the same user on each server? Does that Agent account have the needed permissions in each case? If you open the DTS package and step through each step does it work at that time and only error when executed through a schedule job?
answered Sep 21 '12 at 09:11 PM
Yes, all the users have full access on the folder where the file is getting created. We have checked it, and the users having issue, can create and delete files on that folder.Thanks, Alok
answered Sep 23 '12 at 05:51 PM