Solved

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

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Exceptions 3 35
Need a starter for ETL protocol? 4 33
Auto Login Script 3 12
Adding Subtracting values in sql server 5 0
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.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

932 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now