I think I know what is happening.

When I looked at the execution plan for the query I noticed that the query optimiser was choosing to utilise an index created on...

Hi,

This problems is getting quite frustrating. I left the SQL to finish and it took 2 hours through DTS yet it only takes 2 mins in query analyser. I...

What is the "list" being created for?

Thanks, that worked perfectly!

Being a little concerned I've looked into my data warehouse and I can see from the load control tables that over the last 4 months an average 400,000 records have...

Thanks, that confirms my understanding of a how a timestamp works. Does this mean I can query the table using the timestamp in T-SQL as I have tried above?

Thanks Daniel.

Thanks Kenneth,

I think I should do some more digging into timestamp fields to get a clear idea of how they work. I say this because I believe we have an incremental loading proceedure for...

Kenneth,

I just got this from books online because my understanding of the timestamp is slightly different.

'Every time that a row with a timestamp column is modified or inserted, the incremented database...

Unfortunately the field isn't NULL but populated with the wrong values. However I can probably hijack the status flag on the record for the purpose of the update, and...

I haven't used the SET NOCOUNT option. Does this have an effect on performance?

Thanks, Daniel

I change all of my task names so I can track the package progress through the logs.

You need to be careful that you keep the connection between the Task and...

The first thing I would try is to run the DTS package in the designer as you might spot the offending step by eye when it runs and fails. From the...

I don't think this is possible using and Execute SQL task.

However you can set the global variable through T-SQL using a dynamic properties task.

I thought you might have tried that

I don't have the Sysbase ASE ODBC driver to try this. Could it be using Intergrated NT...

Have you tried typing a password into the property value?

If you are trying to change the database connection password then this will depend on your connection type. If you are connecting via ODBC via and OLEDB connection then look...