asked
DTS Package not executing on some machines
Hello, 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
without some more details (e.g. some error messages) it'll be a bit difficult to give you an appropriate answer. As Thomas asked: where there any changes?
The error message is - 1 tasks failed during execution. There are two tasks total in the DTS package. 1. Transform data task 2. Activex Script task The error comes in the first task only. First task queries the data from the database and creates a file on one location. I have checked I have full rights on that location. I can create/delete files there. I am connected with Windows Authentication. There has been no changes on the machines apart from Auto Updates running on specific intervals. Any help appreciated. 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?
Hello Tim, I am sorry that my question was not clear. The DTS package is on one SQL 2005 server only (under legacy). Our support team members some times need to run the DTS package as per the requirement. All the support team member's IDs are added in one Active Directory group. And that active directory group has added as an user in the SQL server. So all the support team members open the SQL server management console with the windows authentication. The problem is - some of them can run the DTS successfully, whereas some of them not. Interesting thing is - the package used to be run on every user's login properly. All the users system are getting updated through Auto Updates run by our IT team. It is frustrating as it is difficult for providing support to the application. One option we are considering is to convert the DTS into SSIS package. Thanks, Alok
Hello Tim, 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
11 People are following this question.
