?
Solved

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

Posted on 2008-10-21
3
Medium Priority
?
452 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 1200 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

770 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