My gut feeling is that your package doesn't even fire OnError because it failed at the validation level. You can put a debug message in OnPreValidate event to see what...

Thanks for your advise. The reason I don't like logging is the text file format is kind of messy. Here is a part of my package execution log. Am I...

Thanks Crispin.

You can create a variable e.g. sQuery. In the script task you make this variable writable (specify it in the ReadWriteVariables field) and then set the value of this...

Thank you guys for the response.

I am trying to use this connection string which I have got from a colleague, haven't tried it successfully. But I was told it...

Yes, you can. But you need to install the sql2000 backward compatibility component which you can get for free from msdn website.