I'd start w/ the network adapter on the active node - are you running 100mbps or 1000mbps? Full duplex? What is the response when running a tracert? Good luck 🙂

Fingers crossed, thanks Andras 🙂

select @@servername should return the name of your server in which case I'm assuming you just want to change the registration properties within EM? You can delete the registration in...

If installed prior to 02/29, any ideas wether or not services will come back online after 03/01 or are we looking at a reinstall?

Are you using SQL or SSPI authentication for the OLEDB connection in your second package? Are you storing the package in msdb or on the file system?

Andras - I've been beating my head against the wall all morning trying to figure this out. Thanks for the post - at least I'm not going crazy 😀

NP, Good luck 🙂

Try -

@[User::Path] + "\\" + "Holdings_" + (DT_STR,4,1252) DatePart("yyyy",getdate()) + Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) + Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2) + ".csv"

Keep in mind that sp_updatestats updates statistics by using the default sampling which is typcially 10%. I would recommend a fullscan.

NP 🙂

Use a WHILE loop to incrementaly update the records using a ROWLOCK hint. A crude example, but you get the idea 🙂

create table ##UpdateRows(somePK int)

insert into ##UpdateRows

select somePK

from sometable

where something...

You could also acomplish this within a script task. Let's assume you have the following variables:

FileDirectory, string, C:\TEMP

FileName, string, SomeFileName.csv

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.IO

Public Class ScriptMain

...

Have you updated your statistics? Run a DBCC SHOWSTATISTICS (tableName, IndexName) on some your larger tables, post the results. You may need to update statistics with a fullscan (sample script...

NP 🙂

Have you tried disabling the service? Did the event logs reveal any information on what account/process is responsible for restarting the service?