Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
| Search | Today's Posts | Mark Forums Read
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old December 22nd, 2004, 12:29 PM
Authorized User
 
Join Date: Jun 2003
Location: , , .
Posts: 45
Thanks: 0
Thanked 0 Times in 0 Posts
Default DST schedule job failed.

Hi,

I logged on as SA to create a DTS package to create an Excel file on a network drive and import the query result to that Excel file. When I tried to run the DTS, it ran thru all. When I created a job to schedule the DTS, it was failed. I had the following errors:
Executed as user: DSHS\hrdadmin. ...OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error string: Error Code: 0 Error Source= Microsoft Excel Error Description: Microsoft Excel cannot access the file '\\dshsasdfps1\Shareroot\home\buibt\ASDExcel'. There are several possible reasons:  The file name or path name does not exist.  The file you're trying to open is being used by another program. Close the document in the other program, and try again.  The name of the workbook you're trying to save is the same as the name of another document that is read-only. Try saving the workbook with a different name. Error on Line 44 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error Detail Records: Error: -2147220482 (800403FE); Provider Error: 0 (0) Error string: Error Code: 0 Error... Process Exit Code 1. The step failed.

PLEASE HELP!
Thanks!
  #2 (permalink)  
Old December 22nd, 2004, 03:32 PM
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

[u]Few questions</u>

1. does your excel file exist?
2. Under what credentials are you using the run the job?
3. Does the account used in #2 have the permission to the folders and or server?

Try creating the account on the server and not from your local workstation or pc. When you create the DTS from your workstation it runs from your local workstation and uses the security contents of the local workstation and since it may not have the proper security the job fails.

check the job is run using the an account with sufficient privileges, avoid using the the SA account


Jaime E. Maccou
  #3 (permalink)  
Old December 23rd, 2004, 03:28 PM
Authorized User
 
Join Date: Jun 2003
Location: , , .
Posts: 45
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am happy now. I found out that because MS SQL server is running under system loggon account. So I did set MS SQL server have the same account the Agent service account and set permission for that account to have write access to my folder on the network drive.

To answer few questions from jemacc
1. No the Excel file is not existed.
2. I am running the job under my window authentication
3. No.

Thanks for your looking in my question. Appreciated your times!
  #4 (permalink)  
Old December 23rd, 2004, 03:59 PM
Friend of Wrox
 
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

Okay,

So what is your status now? Is everything working for you?

Jaime E. Maccou


Similar Threads
Thread Thread Starter Forum Replies Last Post
job schedule every minute for a stored procedure dfgilto SQL Server 2005 1 February 7th, 2008 07:30 PM
About schedule Task brijit VB.NET 2002/2003 Basics 1 November 8th, 2006 01:21 PM
Activity schedule edubbelaar Access 3 November 24th, 2004 11:21 AM
schedule in calender rita General .NET 0 June 19th, 2004 03:37 PM
Schedule a sychronisation ppenn Access 1 November 12th, 2003 09:45 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.