The subject of this question is the error which I am receiving when running a scheduled job also this is an error which we get at a random intervals and the frequency would be once or twice in a month. I have been through several posts and didn't concluded
anything out of it. At the time when we receive this error the memory usage of the database was normal with free resources available and also the network was stable without issues.
Our Sql database is in cluster mode with named instance.
Can anyone share some information on this, I know this is not the right forum with the error message I have posted but am sure some one might have face the same problem when running some ETL jobs. Source and target both are sql server and the error message
is generated in the validation phase of the connection manager connecting to target database.
SSIS 2005 SP2
64 bit environmentRaju
View Complete Post