I have written a Activex DTS package, but times out with 2 different errors. Sometimes I get the query timeout after about 30 sec's else it timesout after 5 minutes. Even if I execute it on the server I get the same problem. I have tried using the connection string time out properties but still get the same. All the db properties all seem to be right and set to unlimited ? Is there a list of ones you can configure ?
Cheers,
Cheers,