mercwrought
Programmer
Hi all hate to repeat myself but the DTS package thread is really quiet. I’ve got this DTS package acting up that does not make sense. Here is the link to my other post.
It is acting like the statements in an SQL Task in a DTS package are being executed at the same time and not in the order they are listed in the SQL task.
In a DTS package, inside of an SQL Task if there are multiple queries does the server try to execute them concurrently?
I was informed that it tries unless you put a “GO” after each query to force the batch.
Any thoughts? Thx for any responces.
It is acting like the statements in an SQL Task in a DTS package are being executed at the same time and not in the order they are listed in the SQL task.
In a DTS package, inside of an SQL Task if there are multiple queries does the server try to execute them concurrently?
I was informed that it tries unless you put a “GO” after each query to force the batch.
Any thoughts? Thx for any responces.