Dtexecui.exe

Nov 29, 2006

When I try to run a .dtsx file or even the Dtexecui.exe I get following error:System.IO.FileNotFoundException.





Thanks

Bill

View 1 Replies


ADVERTISEMENT

DTEXECUI.exe Not Installed?

Dec 26, 2007

Hi all,

I have a DTEXECUI.exe related question. This util is installed on our QA server, but not our dev-server. Is this optional during installation? I can't ask our admin, he's on vacation.

Maybe important to note, is that the QA-server runs on 64 bit, where as the other servers are only 32-bit..

Regards & Season greetings,

T.

View 4 Replies View Related

Taming The UI In DTexecUI

Feb 7, 2007

Is there an option(s) that will allow me to reduce the amount of output to the Package Execution Progress window? My package has a number of steps, but trying to keep track of progress is difficult at best given the deluge of messages this window displays.

I would prefer output similar to the SQL Import/Export wizard, which shows executing tasks on a single line with a status and a link to any error messages off to the side. Is this available somehow, or do I have to build it myself?

Thanks, any help appreciated.



View 2 Replies View Related

Different Behavior Between DTExecUI And Scheduled Job

Oct 31, 2007



I have a very simple SSIS package that reads an environment variable, assigns it to a variable that is sent in an email, and also logs it to a text file. If I execute the package on the server via DTExecUI, it works fine as expected. However, if I schedule it as part of a job, I get the following error:


Code: 0x00000002 Source: Script Task Description: The script threw an exception: Object reference not set to an instance of an object. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:08:00 AM Finished: 9:08:01 AM Elapsed: 0.859 seconds. The package execution failed. The step failed.

The script is as follows:


Imports System

Imports System.Data

Imports System.IO

Imports Microsoft.SqlServer.Dts.Runtime


Public Class ScriptMain


Public Sub Main()


Dim Path As String = "C:TestEnv.txt"

Dim Env As String = Environment.GetEnvironmentVariable("SSISConfig").ToString()

Dim Sw As StreamWriter


Dts.Variables("SSISConfig").Value = Env


If File.Exists(Path) = False Then


Sw = File.CreateText(Path)

Else


Sw = File.AppendText(Path)

End If

Try


Sw.WriteLine(Env)

Finally


Sw.Close()

End Try





Dts.TaskResult = Dts.Results.Success

End Sub

End Class


I have puttered with this for a while now and can't figure out what the problem is. Any ideas?

View 12 Replies View Related

Problem With SSIS (dtexecui?) After Sp2

Nov 12, 2007

I installed SP2 yesterday on our production server. I had some
problems with that but it seemed to have installed so that the Datbase
engine and the Integration Services is patch at least.

But after the update we can no longer bring up the "properties" of
SSIS packages. If we connect to the integration service and choose run
package the GUI just wait for a while and then nothing happens. We get
an error in the event log thou ..


Event Type: Error
Event Source: .NET Runtime 2.0 Error Reporting
Event Category: None
Event ID: 5000
Date: 2007-11-12
Time: 10:51:07
User: N/A
Description:
EventType clr20r3, P1 dtexecui.exe, P2 9.0.242.0, P3 45cd726d, P4
microsoft.sqlserver.manageddts, P5 9.0.242.0, P6 45cd7534, P7 21, P8
14, P9 qg0f5oshpmqbs2pm34uokrbhqqrfhscr, P10 NIL.


Anyone can make any sense of that?

If we open a package that we have scheduled in the SQL Agent we get an
error messages saying "No description found" .. really strange stuff
is going on here ..?

Please, any help would be appreciated ..

View 8 Replies View Related

Encrypting The DTEXECUI Command

Dec 12, 2006

Hi,
I am trying to find a feature- that was there in DTS but I can't locate it in SSIS

Using DTSRUNUI, we could generate a encrypted command line for executing the pacakge. Now using DTEXECUI, I can get the command line but is there any way in which I can get it in the encryted format??

Thanks.

View 3 Replies View Related

System::InteractiveMode Is FALSE From Dtexecui?

Jun 2, 2006

In a script task, I prompt the user for some parameters. I use the System::InteractiveMode variable to tell me if the package was launched via user interaction or from an automated process such as a file watcher. I display the prompts only if System::InteractiveMode is true. When I run from VS 2005 then I get the prompts, and when the package runs automated (dtexec) the prompts are not shown, so all is OK. However, when the package is run from dtexecui, I do not get the prompts because it seems the InteractiveMode value is false. Shouldn't the InteractiveMode value be true when the package is run from dtexecui since it is a user interface?

View 3 Replies View Related

Oracle SSIS Runs In DTExecUI, But Not In 32-bit DTExec

Aug 28, 2007



I've worked for awhile to get an SSIS package that connects to Oracle to succesfully run via DTExecUI from a 64 bit SQL Server. I completely understand that DTExecUI runs in 32 bit mode, but I need to initiate the package from a stored proc so I need to be able to utilize the 32 bit DTExec from either a xp_cmdshell call or from an sp_start_job (thanks to MatthewRouche for the suggestion). Both Ora92 and 10g were installed on the SQL Server.

Here's what I've tried unssuccessfully

1. SQL Job - Just calling the package from an SSIS step. I wouldn't expect this to run because it is 64 bit DTExec.
2. SQL Job - A job that calls the 32 bit version of dtexec from cmdexec. Here is 2 examples I have tried, the first is because I came across several postings saying that there is a problem with the "(x86)" for the Oracle driver.


\server_nameE$ProgramFilesLegacyMicrosoftSQLServerX8690DTSBinnDTExec.exe /DTS "PackageName" /SERVER "SERVER_NAME" /SET Package.Variables[PLT].Value;"8H" /CONFIGFILE "\SERVERConfigFile.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW

\server_nameE$Program FilesMicrosoft SQL Server (x86)90DTSBinnDTExec.exe /DTS "PackageName" /SERVER "SERVER_NAME" /SET Package.Variables[PLT].Value;"8H" /CONFIGFILE "\SERVERConfigFile.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW

Both of these give me the error below:


System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.


I'm assuming that it is running in 32 bit mode because this was at the beginning of the job history log:

Executed as user: "XXX". ....3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved

3. I then tried to call the package from a batch file on a file server that had integration services installed on. Got the same error as above.

I'm obviously missing something if I can get it to work in DTExecUI but not DTExec 32-bit.

Any ideas? Below are some postings I have already visited several times:

Windows 64 bit and Oracle
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=358365&SiteID=1

Connecting to Oracle on 64-bit (x64) machine
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=159581&SiteID=1

One paragraph that stands out on this posting is:

Find the location of the application that is generating the error. Check the path to this location and see if it contains any parenthesis. If so, you must relocate the application to a directory without any parenthesis in the path.
This didn€™t work for me, unless I was doing it wrong.

Error retrieving numeric data from Oracle 10g on 64 bit Itanium SSIS server
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1183296&SiteID=1

Connection Problems to Oracle Database
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1307460&SiteID=1

If this posting was complete, it looks like what I was looking for.

View 9 Replies View Related

Problem Setting Package Properties From Dtexecui

May 17, 2007

I want to input a parameter to my package. I have a variable, and I tried changing its value from DTExecUI.

I did everything as mentioned in http://blogs.conchango.com/jamiethomson/archive/2007/03/13/SSIS_3A00_-Property-Paths-syntax.aspx but I still get an error -

Could not set "Package.Variables[User::var_input_step_Name].Properties[Value]" value to "RAW".



The variable was originally read from a XML config file. I stored the package to MSDB. I then ran dtexecui, selected my msdb package, and in Set Values, I entered property path and value. I also tried removing the "", and I even deleted the XML configuration. Still the same error.

What am I doing wrong? Any Package Settings to make?

TIA

Kar

View 4 Replies View Related

DTExecUI - Package Execution Utility Error

Nov 7, 2006

Hi,

when i deploy my package using the DTExecUI thru the Package Execution Utility.when we execute the package . we are getting the following error.

The Product Levelis insufficient for component "Flat File Source(1)"

the package design is

FlatFileSource ----> OlEDBDestination

what could be the solution for this?

Thanks

Jegan

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved