Sorry I am not even getting to execute code, this error happens when trying to connect to the database engine remotely. I have increased the remote timeout but still...

thats great and has cleared it up for me thankyou

It is directly through SSMS.

The database I am connecting to is a SQL 2005 OLTP DB. The Auto Close is set to false.

Ok I have found the scale drop down in the data tab, but still it doesn't change the mi, max and avg fields to anything other than to 0 or...

Ok that seems seinsible I will try that.

Thanks

Paul White NZ (3/30/2010)

---

What is max server memory set to at the moment?

Which edition of SQL Server are you running?

32 or 64 bit?

Is the server dedicated to SQL Server, or...

ok great thanks for your replies.

Hi thanks again for the reply.

In regards to the FTP logging I will look more deeply into the component itself.

As for the executing of the job, I eventually setup the...

hi thanks for your reply - it seems I had put in the wrong information into the environment variable, once I re-installed the package the config was picking up.

I do...

Right I have added a variable as a String and added the name of the operator to it.

I have then tried to add that variable to the notifyoperator expression property,...

yes but with that how can I write the failure message to my logfile? Preferably I would prefer the taks to fail not complete with failure if you see...

yes the variable was read\write as it wouldn't correctly save if it wasn't I noticed.

However I have found out that the postexecute mthos only executes after the data...

Hi all - thanks for the replies it has given me something to start with. What about alerting on severity errors also I take it thats worth tracking?

Some further info - I have traced the error logging back to a procedure in the Distribution database called [sys].[sp_MSrepl_raiserror]. I would like to alter this proc to raise...