August 1, 2016 at 1:19 pm
Hello,
I am trying to run an SSIS package on SQL agent for sQL server 2008 r2, i get this message below:
Executed as user: CHLA\CHLADBENTSSRS$. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4321.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:10:28 PM Error: 2016-08-01 12:10:28.12 Code: 0xC0011007 Source: {4DB361AC-6104-4F75-8C81-046595F24229} 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: 2016-08-01 12:10:28.12 Code: 0xC0011002 Source: {4DB361AC-6104-4F75-8C81-046595F24229} Description: Failed to open package file "D:\SSIS\Arisys_DB_Import\Integration Services Project1\Arisys_DBA_SSIS.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 "D:\SSIS\Arisys_DB_Import\Integration Services Project1\Arisys_DBA_SSIS.dtsx" because of error 0xC0011002. Description: Failed to open package file "D:\SSIS\Arisys_DB_Import\Integration Services Project1\Arisys_DBA_SSIS.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: {4DB361AC-6104-4F75-8C81-046595F24229} Started: 12:10:28 PM Finished: 12:10:28 PM Elapsed: 0.062 seconds. The package could not be found. The step failed.
I have tried to put the SQL agent task in 32 bit runtime under execution options that didnt work. I am running the dstx package by itself. however if i go into visual studio and run it plus making sure i go to properties of the ssis package project 1, then to debugging, and set to false on "RUN64BITRUNTIME", it works fantastic, i guess i am wondering how i can run the entire SSIS project 1 .dtproj so i can get the dstx package to work :(????
any ideas?
August 2, 2016 at 6:31 am
"D:\SSIS\Arisys_DB_Import\Integration Services Project1\Arisys_DBA_SSIS.dtsx"
Does this path exist on the server or is this on your local machine?
When you add a SSIS job step the file browser opens to your local machine, however when actually run the job it it will interpret the path to be on the server.
Deploy the package to the server or a share and use UNC paths where possible.
August 2, 2016 at 8:58 am
Hey Spiff, thanks for helping 🙂
Yes this is an actual local drive, its not a mapped drive or anything. The only thing that frustrates me more than anything about my environment when i was hired is the Fact that THEY ARE USING "NETWORK SERVICES" to run SQL services.. ugh.
the only error i get besides the one from my last post is:
Message
Executed as user: CHLA\CHLADBENTSSRS$. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4321.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 7:57:14 AM Error: 2016-08-02 07:57:19.14 Code: 0xC0202009 Source: ArisysDB_ETL Connection manager "SourceConnectionOLEDB" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.". End Error Error: 2016-08-02 07:57:19.15 Code: 0xC020801C Source: Data Flow Task 1 Source - Address [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2016-08-02 07:57:19.16 Code: 0xC0047017 Source: Data Flow Task 1 SSIS.Pipeline Description: component "Source - Address" (1) failed validation and returned error code 0xC020801C. End Error Error: 2016-08-02 07:57:19.16 Code: 0xC004700C Source: Data Flow Task 1 SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2016-08-02 07:57:19.16 Code: 0xC0024107 Source: Data Flow Task 1 Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:57:14 AM Finished: 7:57:19 AM Elapsed: 5.094 seconds. The package execution failed. The step failed.
could it be that someone is using the access database, which will prevent the SSIS package from extracting data from it?
August 2, 2016 at 10:53 am
The standard question is "Does the account running the package have access to that file?" It's just one of those things you have to ask.
The next one is whether or not you're using a configuration file. If you are and leave the box checked it will look for the file where it was created. If it can't find it (and it won't if it's running at the server) then it gets crabby.
August 2, 2016 at 10:58 am
thanks JustMarie for your input, what and how do i create the configuration file so i can tell it the says FALSE for the "Run64Bit" thing? again its got to be that, and not sure if and how to create the configuration file, i mean i know how, but not sure what check box to check specifically to make sure it says false for running "Run64Bit"??
August 3, 2016 at 9:57 am
At the package level you can do it from Project Properties, debugging.
I don't have a package with a configuration file handy so I can't point you to where that would be but my guess would be in the package section.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply