Thanks,

This wont let me install as it's part of XP SP2 (there was an error message but I don't have exact details right now).  So far I haven't managed to...

When it appears to update but does not this has usually been down to the connection not being what we thought it was.

Reasons for this are :

1. Connection object has...

I can create an ODBC if that's what you mean.  It just that most connection types in DTS give this error.  Connection types such as text and Excel appear to be...

I agree with Pam that it may not need fixing.  We do have some (rare) occaisions where the tempdb locks are causing memory issues,  when this does happen (and only...

Can you say what the error is, I have found the most common problem is connections rather than accounts but it depends on several things.

In general it is better to think in terms of getting the data into SQL first, if necessary into an intermediate table that mirrors the csv. Once in a SQL...

Be aware that once Oracle Client is installed on the SQL box then the server needs rebooting before it's fully recognised by SQL. I believe that this is to do...

The best way to do this is to use the dynamic property task. You can set the variable from a query or various other (e.g. ini file)

A couple of things that we have done with similar issues are

1. use with (tablockx) to avoid the use of multiple page locks  (if this is a problem you will...

You can use the following syntax to insert the value in the task.

insert into Table1(message) values (?)

I can't answer your question directly but we disable steps using Dynamic Property Task and setting the DisableStep property to 1. For our purposes we use a table that switches items...

We have found Case Studio 2 to be good and not very expensive. You can create drawings by importing the SQL and vice-versa, so it gives you that bit more...

Narrow this down to the column in question by building a test transform with reduced columns (if the error does not give you this).

Use the len() function on the source...

I don't know if this is exactly the same but when importing from excel, DTS reads the first 8 lines (by default) and makes assumptions on those lines as to the...

Scott,

You may not want to sound like a flame but you do sound a little miffed.  One problem is that this issue is on a customer site, we have no way of creating...