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)
 DTS Package failed

Author  Topic 

DBA007
Posting Yak Master

145 Posts

Posted - 2010-05-24 : 16:09:33
One of my DTS package failed with below error

XXXX\SQLADMIN. Microsoft (R) SQL Server Execute Package Utility Version 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:00:00 AM Error: 2010-05-24 09:25:58.71 Code: 0xC002F210 Source: Exec Proc Execute SQL Task Description: Executing the query "exec intf_PersonnelLoad" failed with the following error: "Unspecified error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:00:00 AM Finished: 9:25:58 AM Elapsed: 1558.22 seconds. Process Exit Code 1. The step failed.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-05-24 : 16:19:35
Unfortunately that's not enough information. To figure out what the problem is, you have to log into the database server directly (RDP, console, etc...) using the SQL Server service account, which appears to be XXXX\SQLADMIN in your case. Then open up the package and manually run it. Let us know what happens when you manually run it under that account.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -