No query hints in my post either.

I agree - examine the process. Are the users selecting the data that is being updated? How long is the update taking?

If...

The transaction log file growth can be managed by doing transaction log backups more regularly. The transaction log file will grow large enough to handle the transaction between backups....

Any time.

In this instance, you probably will not need it.

Since there are no indexes involved, hardware is the most likely suspect and then parallelism.

Neither server has much for options in the optimization area because they have to do a...

My guess is that the source schema is changing. You should log errors, but I think you probably have a rather poor DB2 driver (are there any good ones?)...

You could re-join these with a MERGE JOIN component.

I think you are getting to the point in which you should be considering using the script component or creating a custom...

Technically, it is a message, not an exception. Something on the SQL end sent an email (I assume in your stored procedure). When you send a mail message...

There are not a lot of tips and tricks for RS setup. The documentation is pretty good so just follow the steps. If you put Reporting Services on...

I am assuming that the format of the spreadsheet is the same regardless of the recipient.

This can be done through SSIS by looping through all of the doctors, exporting the...

The point about the oSQLCommandTimeOut is that you declare this object and never use it.

Replace:

oSQLCommandTimeOut.CommandTimeout = 1000

With:

oSqlCmdList.CommandTimeout = 1000

The oSqlCmdList object is the one that you are using to fill...

You are trying to use a Data Conversion component on a server or workstation that does not have an SSIS server installed.

The computer EXECUTING the package (not the one it...

You set the command timeout on the oSQLCommandTimeOut object but then never use the object again in the function.

You use oSqlCmdList to fill your data adaptor but never set the...

You connected to a Database Engine, not an Integration Services Server.

Go back to your instructions and make sure you follow the step:

'In the Server type box, select Integration Services.'

Triggers will fire - I have needed that to happen before. I think there may be a setting on the article to disable them though.

So you only have a "Running Packages" folder, or you have no folders listed at all in object explorer?