Error executing SSIS packages from Agent RRS feed

  • Question

  • Hi All,

         I designed SSIS package that loads data from Oracle table to SQl server table along with loading data into Diension and fact tables using SSIS packages only. First I created all SSIS packages that loads data into Staging tables from Oracle table in next level loading data into Dimension table and final level is loading data into Fact table. At lasts I created One master package there I'm calling all packages (Execute package task) differently.

    Configuration type: Parent package configuration for All child packages. XML config for parent package.

    When I execute SSIS package from BIDS data is loading up to Fact table. When I execute SSIS packages through Sql server agent ( Using File System Deployment)When I execute SSIS package from Sql server agent it is throwing an error message like 

    Executed as user: . Microsoft (R) SQL Server Execute Package Utility  Version 11.0.2100.60 for 32-bit  Copyright (C) Microsoft Corporation. All rights reserved.    Started:  10:45:10 PM  Error: 2013-10-17 22:45:12.60     Code: 0xC00220E6     Source: Master Data      Description: There is no project to reference.  End Error  Error: 2013-10-17 22:45:12.61     Code: 0xC0024107     Source: Master Data      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  10:45:10 PM  Finished: 10:45:13 PM  Elapsed:  2.59 seconds.  The package execution failed.  The step failed.

    I'm uploaded config file also while at the time of scheduling job.



    Regards, Praveen

    Thursday, October 17, 2013 5:38 PM


All replies