August 7, 2014 at 3:37 am
Hi All,
I am having a trouble running a job through SQL server Agent . I have 3 packages where one is Master package and the other 2 are the child packages which are called from the Master package and i have created the XML package configuration in all of the three packages ( for the connection string of the source and destination )
When i try to run the child packagefrom sql server agent they are working fine but When i try to run the Master package i am getting following Error , pls help me out over here
Message
Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 2:52:17 PM Error: 2014-08-07 14:52:18.33 Code: 0xC00220E6 Source: Execute Package Description: There is no project to reference. End Error Error: 2014-08-07 14:52:18.33 Code: 0xC0024107 Source: Execute Package Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:52:17 PM Finished: 2:52:18 PM Elapsed: 0.672 seconds. The package execution failed. The step failed.
The project is in the Project Deployment mode
August 7, 2014 at 4:16 am
As you're using project deployment, you must be on SSIS 2012.
So your config info should be coming straight out of an SSISDB environment - no XML required.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
August 7, 2014 at 4:18 am
Could you please explain that a bit please
August 7, 2014 at 5:05 am
Have a read here and see whether it makes sense, then come back with any follow-up questions.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply