DTS Error --- Error string: The file exists

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Data Transformation Services (DTS) » DTS Error --- Error string: The file exists

23 posts, Page 1 of 3

1 2 3 »»»

DTS Error --- Error string: The file exists

Rate Topic

Display Mode

Topic Options

Author

Message

Rajarshi Mukherjee

Posted Wednesday, April 01, 2009 8:06 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 27, 2009 8:17 AM
Points: 18, Visits: 56

I have developed a DTS job which is running fine if execute it by right clicking on it. But whenever I schedule it as a job to be run later, I am getting the below error message.

Executed as user: IUSER\BTIS0402. DTSRun: Loading... Error: -2147024816 (80070050); Provider Error: 0 (0) Error string: The file exists. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 713. Process Exit Code 1. The step failed.

What could be the possible reason for this? I searched a lot in web but in vain

Post #687931

Steve Jones - SSC Editor

Posted Wednesday, April 01, 2009 11:38 AM

SSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 1:47 PM
Points: 31,406, Visits: 13,722

Maybe you could provide some information about what the package does? Where the error might be.

If you have a file exists, have you checked for that?

The execution on the server takes place in the context of the server, so the SQL Agent account, it's drive mappings, etc. When you run it from your workstation, it's running from there, not the server.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #688227

Rajarshi Mukherjee

Posted Thursday, April 02, 2009 3:27 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 27, 2009 8:17 AM
Points: 18, Visits: 56

Please find the attached pic of the DTS.

Functionality -
----------------
1) Truncate all the temporary tables at starting point of the execution

2) Source file path is given of the CSV file which will be received every after 5 mins from interface system. File will be moved once loading is finished so file path directory is always empty when the DTS is being executed.

3) File will be loaded in in database using transformation task

4) Once file is loaded P_VDMT_EXTRACT stored procedure will be executed which is responsible for some data manipulation and population of output extract table.

5) If the stored procedure throws any error then error output extract file will be generated ( LEFT SIDE ) otherwise output extract file will be generated taking data from output extract table via transformation task (RIGHT SIDE).

Now I am getting the error in step 1 itself.

Post Attachments

DTPpic.jpg (19 views, 21.95 KB)

Post #688651

Rajarshi Mukherjee

Posted Thursday, April 02, 2009 3:37 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 27, 2009 8:17 AM
Points: 18, Visits: 56

FYI This DTS jobs are running fine earlier. But few days back the SQL agent account has been changed and stopped working and showing the mentioned error message. Not sure how this is possible !!!

I then chased the DBA guy and but as per him, the SQL agent a/c has sufficient permission to access the drive from where the input CSV file is being picked up for loading.

What could the other reasons for this error message. Surprisingly I couldn't find a single entry in google regading this error type. Am I the first person who is facing such problems???

Post #688661

Rajarshi Mukherjee

Posted Monday, April 06, 2009 10:05 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 27, 2009 8:17 AM
Points: 18, Visits: 56

Dose anyone has any answer ?

Post #691201

Timothy J Hartford

Posted Tuesday, April 07, 2009 7:00 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 22, 2012 8:02 AM
Points: 242, Visits: 502

Did you try logging in to the network as the SQL Server Agent account (may need to involve your DBA), right clicking the job, and see if it runs? If it does, than it is not a permission issue, and may be a problem similar to what I have seen (where a scheduled job "loses" the proxy user it was trying to run as, and instead runs as anonymous). If it doesn't, then your DBA is mistaken and the account does not have sufficient permissions.

Post #691944

surendrababu.p

Posted Monday, April 13, 2009 2:11 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, April 26, 2009 1:26 PM
Points: 2, Visits: 5

Hi,
I am the second person who faced similar issue with DTS pacakge with the same error message.
===========================
Execution failed with the following error: "ERROR : errorCode=-2147024816 description=The file exists.
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".
===========================
I am running this using shell script.
I also had extensive search ion web but no use.
Any thoughts on how to solve this?
Any help or info is really really appreciated.
Thanks in advance

Post #695586

surendrababu.p

Posted Tuesday, April 14, 2009 3:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, April 26, 2009 1:26 PM
Points: 2, Visits: 5

Does any one have any details on this? please help in resoving this?

Thanks in advance

Post #696384

Rajarshi Mukherjee

Posted Wednesday, April 15, 2009 4:41 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, April 27, 2009 8:17 AM
Points: 18, Visits: 56

Hi Timothy,

I have checked with the help of DBA for both SQL Agent a/c & my personal a/c. DTS is running fine whenever i am running it manually by clicking "Execute" option. But getting error when i am scheduling it as a job

See the error message --

The job failed. The Job was invoked by User IUSER\602336842. The last step to run was step 1 (ISDN30 - VDMT Extract Generation 1 2).

Executed as user: IUSER\BTIS0402. DTSRun: Loading... Error: -2147024816 (80070050); Provider Error: 0 (0) Error string: The file exists. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 713. Process Exit Code 1. The step failed.

What could be the possible for this?

Post #697374

Timothy J Hartford

Posted Wednesday, April 15, 2009 8:42 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, August 22, 2012 8:02 AM
Points: 242, Visits: 502

Can you provide some additional detail as to the steps within your DTS package?

Post #697594

« Prev Topic | Next Topic »

23 posts, Page 1 of 3

1 2 3 »»»

Permissions