RE: Can't execute SSIS package with Dtexec on cluster node

Tech-Archive recommends: Fix windows errors by optimizing your registry

I spoke with our DBA about your proposed solution and he is not sure it will
work. He suggested I explain our environment in more detail to you. So here
goes:

There are two servers in a cluster: DWHSQL1 (the default instance) and
DWHSQL2 (the named instance). All the SSIS packages are stored on DWHSQL1.
All of their executions are fired from jobs running on DWHSQL2. One job in
particular runs a package that reads data from an Excel spread***. Because
of this, the package must run in 32-bit mode. In order to do this, I have
written an SSIS package that has only one task in it. That task is an
Execute Process task. Its executable is "C:\Program Files (x86)\Microsoft
SQL Server\90\DTS\Binn\DTExec.exe". Its Arguments property is "/SQL
\PnL\MarketingAllUploadXLSPIACCosts /Server dwhsql1". I have tried running
the package thru a job on DWHSQL2, but it fails. To get a better
understanding of just why it fails, I am attempting to run DTexec from
command line.
--
EagleBeek


"Adams Qu [MSFT]" wrote:

Hello,

Thank you for posting here.

From the problem description of the post you submitted, my understanding
is: You have received the connection errors when attempting to run the
following command on the server with named instance of SQL Sever.

"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /SQL
\PnL\MarketingAllUploadXLSPIACCosts /Server dwhsql1

If I have misunderstood about your concern, feel free to let me know.

First of all, I would like to explain that SSIS can only use default
instance by default. If you want to use it on named instance, we need to
manually edit the file "MsDtsSrvr.ini.xml" to specify the server instance
name. By default, the MsDtsSrvr.ini.xml file is located in the Program
Files\Microsoft SQL Server\90\DTS\Binn folder.

1. Located the configuration file at %ProgramFiles%\Microsoft SQL
Server\90\DTS\Binn\MsDtsSrvr.ini.xml
2. Open the file MsDtsSrvr.ini.xml by notepad, and then then correct the
ServerName node in MsDtsSrvr.ini.xml, change the "." into your SQL Server
instance like:

Before:
----------
<ServerName>.</ServerName>

After:
----------
<ServerName>YOUR_SQLSERVER_INSTANCE_NAME</ServerName>

3. Open services.msc and restart your SQL Server Integration Service.
4. Run the command to test the issue again.

Please let me know the results at your earliest convenience. If anything is
unclear in my email, please don't hesitate to let me know and I will be
glad to help. Thank you for your efforts and time.

Have a nice day!

Best regards,

Adams Qu, MCSE, MCDBA, MCTS
Microsoft Online Support

Microsoft Global Technical Support Center

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Thread-Topic: Can't execute SSIS package with Dtexec on cluster node
| thread-index: Ace0HGQHnV8Log8hRcyxMHxp2mzV4w==
| X-WBNR-Posting-Host: 207.46.19.168
| From: =?Utf-8?B?RWFnbGVCZWVr?= <EagleBeek@xxxxxxxxxxxxxxxx>
| Subject: Can't execute SSIS package with Dtexec on cluster node
| Date: Thu, 21 Jun 2007 08:54:03 -0700
| Lines: 22
| Message-ID: <ADC9DE8C-BE44-4480-B886-05C0173D076D@xxxxxxxxxxxxx>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2826
| Newsgroups: microsoft.public.sqlserver.dts
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.dts:2819
| NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| I have an SSIS pacakge that must be run using the 32-bit version of
| dtexec.exe. This is the command line that I use:
|
| "C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe"
| /SQL \PnL\MarketingAllUploadXLSPIACCosts /Server dwhsql1
|
| Our environment consists of a singe development server and a two-node
| production cluster. When I log on to the development machine and run the
| command line, it works fine. When I log on to the server with the
default
| instance of SQL Server, it works fine. But when I log on to the server
with
| the named instance of SQL Server, it won't run. I get error messages
| regarding connection errors. The package uses configurations heavily,
both
| from environmental variables and from SQL server tables.
|
| I need to make this work when running on the named instance of SQL Server.
|
| Any ideas on what I need to do to make this happen?
|
| Thank you very much.
|
| --
| EagleBeek
|


.

Quantcast