Solved

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

Posted on 2008-10-21
3
436 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
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
point in time restore in SQL server 26 41
sql update 2 35
SQL Server Error while building a sql query using concatenate statements 3 19
Building JSON Results Table FROM DB 9 31
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

685 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