Solved

SSIS - connection was forcibly closed - worked on active/passive cluster, breaks on active/active

Posted on 2008-10-21
3
442 Views
Last Modified: 2013-11-10
We've got a big SSIS package that imports text files into SQL Server 2005.

The thing ran fine through this massive batch of files on our Dev environment ... then on our next environment up.  

On the Test environment, the same package, working against an identical (made from the same script) DB, loading the same files, breaks with errors about the connection being forcibly closed.  The breaks appear to occur randomly.

The only known difference between the working and non-working environments is the cluster configuration.  The working environments use an Active / Passive cluster configuration.  The failing environment uses an Active / Active / Passive configuration.

Our BI guru suspects that connection pooling in the SSIS doesn't get along w/ this cluster configuration.

Is he right?  Or is there something else we should check?

Thanks!
0
Comment
Question by:Daniel Wilson
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 4

Assisted Solution

by:randy_knight
randy_knight earned 300 total points
ID: 22770119
In the failing environment which is active/active/passive, you still only have the instance being loaded to on one node at a time.  So I don't see that the nature of hte cluster would be the issue.  You're still connecting to the virtual name/IP of the instance.  You might check DNS, etc. for the virtual name to make sure you're not getting intermittent issues with that.
0
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 0 total points
ID: 22778013
Thanks, Randy.

Turns out the DBA didn't properly deploy the package to the DB ... though how that caused an intermittent failure, I don't know.

Anyway, thanks for your help.
0
 
LVL 32

Author Comment

by:Daniel Wilson
ID: 22781126
Randy, my comment was wrong.  we're still having the problem.

New question on it is at http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/Q_23838695.html
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql trace 4 25
Failover Cluster Primary Nodes Current Vote = 0 5 34
Begin Transaction 12 25
SQL Simple Query Taking a Very Long Time 11 35
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question