If you don`t already have a table with a distinct ClientID then you really should have one (presumably with the Name and Address which would also normally be unique for...

There are probably still some left over keys in the registry. My advice on your original post was to be to try and install over the top of the existing...

This may be too complicated in your app but I once had to insert to many tables from an app and roll back all if one went wrong.

What I ended...

Adding my 2 bits worth

You might try putting troublesome SQL like this in a messagebox to show you strSQL, or print it...

Also On DTS (sorry, not up to SS2005 yet), this might work:

DECLARE @DateParm DATETIME

SELECT @DateParm = ?

select *

from tableA a

where exists (Select ID

from tableB b

where b.ID = A.ID

and...

Why not just force the error IE:

SELECT @rc = EXEC blablabla

IF @rc = 0 RAISEERROR 'Nothing to process!', 16

Then your OnSuccess link should work

Suggest you move your transactions down to a more granular level to try to spot exactly where it is getting a problem.

Assumption would be that some other process is using...

I am not sure this will be helpful but you might want to consider the data paths:

exec [SERVERNAME].master..sp_executesql N'select * from sysdatabases'

I think this will produce a query plan on...

I may be reaching here but, when you start an explicit transaction with BEGIN TRANSACTION the server will place all following operations in the transaction until you execute COMMIT TRANSACTION...

It has been a while since I have dealt with Text data but looking at the SQL:

SELECT @ptrval = TEXTPTR(NewsText)  --- text is wrapped in the varaible

FROM tblNews

My initial...

I think we need more info, when you say 'I don't seem to be able to defrag the tINDEX_C' what happens when you try? What error message do you get?

The...

Very quickly, you need

1 x SQL Server connection, 1 x Text File (destination) connection, 1 x transform data task (between these 2 connections), 1 x File Transfer Protocol task (after...

If re-ordering the tables in the joins does not work you could try changing the order of the items in the ON clauses.

And that just about does it for any...

Excuse me if I have mis-read your original post but if you just want the output in the order you specified then you could just use the ORDER BY clause...

Without having Windev it is very difficult to say for sure but the problem almost certainly lies with how the JOINs are evaluated.

In some DBs the order of the...