Wednesday, May 16, 2012 3:12 PM
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 Event Name: CLR20r3
Problem Signature 01: dtexecui.exe
Problem Signature 02: 220.127.116.11
Problem Signature 03: 434f5df5
Problem Signature 04: DTExecUI
Problem Signature 05: 18.104.22.168
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?
Wednesday, May 16, 2012 3:15 PM
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?
- Edited by Chuck Pedretti Wednesday, May 16, 2012 3:17 PM
Wednesday, May 16, 2012 3:34 PM
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.
Wednesday, May 16, 2012 3:37 PMDoes it run in BIDS?
Wednesday, May 16, 2012 3:43 PM
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?
Monday, May 21, 2012 8:03 AMModerator
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