"EagleBeek" wrote:

>
> -- We tried your suggestion and still got errors.
>
> I made a single-step job that executes this Operating System command and ran
> it from the named instance (dwhsql2):
> "C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /SQL
> "\PnL\MarketingAllUploadXLSPIACCosts" /SERVER dwhsql1
>
> This is the error I get:
> All rights reserved. Started: 10:05:48 AM Progress: 2007-06-27
> 10:05:50.71 Source: Copy Data from Sheet1$Query_from_omadwhdev1OLAP to
> dbo PIACCostsXLS Task II Validating: 0% complete End Progress
> Progress: 2007-06-27 10:05:50.71 Source: Copy Data from
> Sheet1$Query_from_omadwhdev1OLAP to dbo PIACCostsXLS Task II
> Validating: 50% complete End Progress Progress: 2007-06-27 10:05:50.71
> Source: Copy Data from Sheet1$Query_from_omadwhdev1OLAP to dbo
> PIACCostsXLS Task II Validating: 100% complete End Progress Error:
> 2007-06-27 10:05:50.80 Code: 0xC0014019 Source:
> MarketingAllUploadXLSPIACCosts Description: The connection manager
> "Olap" will not acquire a connection because the package OfflineMode property
> is TRUE. When the OfflineMode is TRUE, connections cannot be acquired. End
> Error Error: 2007-06-27 10:05... Process Exit Code 1. The step failed.
>
> I get exactly the same error whether your proposed change was in place or not.
>
> I created exactly the same job and step on a different server that is not on
> the cluster and it ran successfully.
>
> Could this indicate that the problem is on the named instance somehow?
> --
> EagleBeek
>
>
> "Adams Qu [MSFT]" wrote:
>
> > 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@community.nospam>
> > | References: <ADC9DE8C-BE44-4480-B886-05C0173D076D@microsoft.com>
> > <LbWho8KtHHA.1796@TK2MSFTNGHUB02.phx.gbl>
> > <F8F76CE7-7C28-402F-91A8-90CA2882E793@microsoft.com>
> > | 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@microsoft.com>
> > | 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 spreadsheet.
> > 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