Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Executing DTS through SQL Server 2005 Job Agent

Author  Topic  JK Starting Member 1 Post Posted - 2008-11-16 : 18:12:05 Hi I am trying to execute DTS through SQL Server 2005 Job which fails. The following is the error: Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft Data Transformation Services (DTS) Data Pump (80020101): Error Code: 0 Error Source= Microsoft OLE DB Provider for SQL Server Error Description: Invalid input parameter values. Check the status values for detail. Microsoft OLE DB Provider for SQL Server (80004005): Invalid input parameter values. Check the status values for detail. Step Error code: 8004206A Step Error Help File:sqldts80.hlp Step Error Help Context ID:0 Details of execution: - created credentials - added credentials to the proxy acct - set the sp to run create job and job steps and to run as with proxy acct The job is executed with proxy_name (that is job run as : ) if i run this as sysadmin it works fine. if i run this as non sysadmin it fails at Microsoft Data Transformation Services (DTS) Data Pump where it gets data from Excel to a table. i have given non sysdamin user dbo permission on the database and the user has access to the excel file path. Any help!!!! Regards JK