Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Cannot RUN a Package

Unanswered Cannot RUN a Package

  • Wednesday, May 16, 2012 3:12 PM
     
     
    Sign In to Vote
    0

    I opened management studion and under the stored packages i right clicked on a package and tried to run the package but i was getting the export utility message and here are the details:

    Problem signature:

      Problem Event Name: CLR20r3

      Problem Signature 01: dtexecui.exe

      Problem Signature 02: 9.0.242.0

      Problem Signature 03: 434f5df5

      Problem Signature 04: DTExecUI

      Problem Signature 05: 9.0.242.0

      Problem Signature 06: 434f5df5

      Problem Signature 07: 2

      Problem Signature 08: 1d

      Problem Signature 09: System.IO.FileNotFoundException

    can anyone please advice me as how to fix it?

    Thanks

     

     

All Replies

  • Wednesday, May 16, 2012 3:15 PM
     
     
    Sign In to Vote
    0

    What it probabally means is that the package has a dependancy on an assembly that is not installed on the server (in the GAC).

    Has this package worked in the past when executed from that server or is it the first time you have tried running it there?

    Chuck


     
  • Wednesday, May 16, 2012 3:34 PM
     
     
    Sign In to Vote
    0

    chuck i'm running it from my desktop so where should i look for and i have no idea if anyone has run this before as that person is not with us and i'm new to SSIS/SSAS.

    Thanks

     
  • Wednesday, May 16, 2012 3:37 PM
     
     
    Sign In to Vote
    0
    Does it run in BIDS?

    Chuck

     
  • Wednesday, May 16, 2012 3:43 PM
     
     
    Sign In to Vote
    0

    when i open it in BIDS and click on the green arrow nothing happens, how can i check if its running or not. When i open BIDS i click on file >> open and file and then selected the package from the desktop and tried to RUN it, where can i see the execution results?

    Thanks

     
  • Monday, May 21, 2012 8:03 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi thinkingeye,

    Packages can be run in Business Intelligence Development Studio, from the SQL Server Import and Export Wizard, by using the SQL Server Integration Services package execution utilities, dtExec and DTExecUI, or as a step in a SQL Server Agent job.

    Packages are most frequently run in Business Intelligence Development Studio during the development, debugging, and testing of packages. If you run a package from SSIS Designer, the package always runs immediately. When a solution has multiple projects, make sure you set the project that contains the package that you want to run as the startup project before you run the package.

    While a package is running, SSIS Designer displays the progress of package execution on the Progress tab. You can view the start and finish time of the package and its tasks and containers, in addition to information about any tasks or containers in the package that failed. After the package finishes running, the run-time information remains available on the Execution Results tab.

    For more information about running packages in SSIS, please see: http://msdn.microsoft.com/en-us/library/ms141708(v=sql.100).aspx

    Thanks,
    Eillen