It has been a while since I`ve done ADO in VB but it sounds, from the second error message, like you are trying to Open a connection that is already...

A UNION might help get rid of the OR IE:

select ID from TBL where COL1= @a UNION select ID from TBL where COL2= @a

This may or may...

I am not sure what Hemasunder means, you can Delete, Copy etc in a DTS and add in Date control no problem.

If I was writing a DTS for what you...

Oh - one other thing about cursors - don`t forget you can make them more efficient by using Fast Forward Only and the like.

Jeffery - Sounds as though you have found a good reason for using a loop rather than folding the loop into the SQL.

But are you sure that these 'Parts of the...

Because the Temp DB is created each time SQL server is started it takes its collation from the server (or, more correctly, from the 'model' db). If you have databases...

Thanks, but I think you are assuming a type of usage that simply does not occur in our setup.

Once we have the data uploaded (lets say its monthly, but...

Thanks, I think the size of data any one statement in our process has to handle would make it necessary to shrink the log regularly, IE several times during each...

Thanks, sadly that is exactly the sort of thing I am trying to avoid, our app is very CPU & disk access intensive.

I have tested a fixed log file...

I know this query is now fixed but I thought a small point on debugging might help in future.

I often find it useful to change such statements into selects just...

Look up GETUTCDATE() in BOL, this gives GMT whatever the computers local time zone.

Generally speaking you want to avoid using 'IN ({subquery})' as it can be very inefficient. Stick to using the JOIN method.

You might also try formatting the column as text in Excel before importing. We sometimes get a similar problem (but the other way round) where numeric columns containing commas (eg...

I think Jo`s idea makes sense, create a view with something like:

SELECT * FROM HistoryYYYYMM

UNION

SELECT * FROM HistoryYYYYMM

etc....

Then grant permissions as required on the view, then you only need...

I was not aware that the DTS would do this (I have not made much use of DDQs), but I`m not particularly surprised

Are you changing the connection Manually (IE via...