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

Hello,

Thank you for posting here and taking time to provide the additional
information regarding your environment.

According to the information given, I still recommend that we configure the
MsDtsSrvr.ini.xml (my previous suggestion) to troubleshoot this issue since
this setting has resolved many similar issues in the similar environment
based on my experiences.

If you are afraid that this setting may cause some other issues and affect
your business, it is recommended that we first make this setting in a
test-environment. In addition, it is also safe for us to change the value
of <ServerName> in the MsDtsSrvr.ini.xml to the original one later. Thank
you for your understanding and efforts on this issue.

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: Ace3JEUjo4wMQOnETS6q595v2P7+VA==
| X-WBNR-Posting-Host: 207.46.193.207
| From: =?Utf-8?B?RWFnbGVCZWVr?= <EagleBeek@xxxxxxxxxxxxxxxx>
| References: <ADC9DE8C-BE44-4480-B886-05C0173D076D@xxxxxxxxxxxxx>
<LbWho8KtHHA.1796@xxxxxxxxxxxxxxxxxxxxxx>
<F8F76CE7-7C28-402F-91A8-90CA2882E793@xxxxxxxxxxxxx>
| Subject: RE: Can't execute SSIS package with Dtexec on cluster node
| Date: Mon, 25 Jun 2007 05:28:01 -0700
| Lines: 136
| Message-ID: <AA57AAC3-6957-461A-A7E1-C133BFAFFCD2@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:2850
| NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| Any one have any ideas?
| --
| EagleBeek
|
|
| "EagleBeek" wrote:
|
| > 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