Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSMS Job\SSIS due to error 0x80070003 "The system cannot find the path specified."


SSMS Job\SSIS due to error 0x80070003 "The system cannot find the path specified."

Author
Message
ringovski
ringovski
SSC-Enthusiastic
SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)

Group: General Forum Members
Points: 165 Visits: 445
Hi All,

I am logging on to a production M$ 2003 server using a domain administrator account xxxx\administrator. Then starting BIDS and have created a .dtsx package. The package uses a lookup to compare hearings in different Database tables and exports the differences. It runs fine in BIDS.

I then log into SSMS 08 with the same domain account and setup the following;

Security
--------
LOGIN: xxxx\administrator, SERVER ROLES:public, sysadmin, MAPPED: the 2 db's and MSDB sqlAgentoperator, sqlagentuser, slqagentreader

Credential
----------
Admin: Identity, xxxx\administrator with correct password

Proxy
----------
myproxy: Admin with subsystem SSIS packages selected

Jobs
-----------
Hearing job: Owner:xxxx\administrator, only 1 step 'check hearing type',
Edit step: name ' check hearing type', type SQL SISS Package, Run As 'myproxy'
Package Source: File System
Pacakge: C:\Documents and Settings\administrator.xxxxx\My Documents\Visual Studio 2008\Projects\Integration Services Project1\Integration Services Project1\Package2.dtsx



So I have logged in, created and running the package with the same domain administrator account, given it the SQL permissions. Created a credential for a proxy and told the package to use the proxy account to run as. But the package still doesn't run.

Full Error Message:

Executed as user: xxxxx\Administrator. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 1:23:01 PM Error: 2011-10-27 13:23:01.26 Code: 0xC0011007 Source: {883AAF08-4C73-4B47-900B-6B0A3E89C348} Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted. End Error Error: 2011-10-27 13:23:01.26 Code: 0xC0011002 Source: {883AAF08-4C73-4B47-900B-6B0A3E89C348} Description: Failed to open package file "C:\Documents and Settings\administrator.SERVER1\My Documents\Visual Studio 2008\Projects\Integration Services Project1\Integration Services Project1\Package2.dtsx" due to error 0x80070003 "The system cannot find the path specified.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format. End Error Could not load package "C:\Documents and Settings\administrator.SERVER1\My Documents\Visual Studio 2008\Projects\Integration Services Project1\Integration Services Project1\Package2.dtsx" because of error 0xC0011002. Description: Failed to open package file "C:\Documents and Settings\administrator.SERVER1\My Documents\Visual Studio 2008\Projects\Integration Services Project1\Integration Services Project1\Package2.dtsx" due to error 0x80070003 "The system cannot find the path specified.". This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format. Source: {883AAF08-4C73-4B47-900B-6B0A3E89C348} Started: 1:23:01 PM Finished: 1:23:01 PM Elapsed: 0.031 seconds. The package could not be found. The step failed.

Any help would be very much appreciated :-D

I have been browsing the net all day and haven't found anything I have missed, but there must be something.
ringovski
ringovski
SSC-Enthusiastic
SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)SSC-Enthusiastic (165 reputation)

Group: General Forum Members
Points: 165 Visits: 445
Problem is solved Smile if anyone is intrested....

I found that I had to enable deployment from the package properties and build. Then use the deployment tool to deploy the packages to the SQL server MSDB or file system. Then I can use the SQL server agent for most of the jobs and they run fine. There is only one job thats uses a flat file on the server so i have to use a local admin account for that job.
vijayarani87.s
vijayarani87.s
Valued Member
Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)Valued Member (60 reputation)

Group: General Forum Members
Points: 60 Visits: 137
Hi I need one help from u, I am also gettign error while executing package from cmd. Could you please help?
I am getting below two error

1.Unable to load the package as XML because of package doesnt have valid xml format.
2.Failed to open package file due to 0x80070003 error.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search