Post reply

Error : Description: There is no project to reference.

  • August 7, 2014 at 3:37 am

    #289592

    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

    #1735896

    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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • August 7, 2014 at 4:18 am

    #1735898

    Could you please explain that a bit please

  • August 7, 2014 at 5:05 am

    #1735911

    Have a read here and see whether it makes sense, then come back with any follow-up questions.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply