Thanks but I don`t think you understood.

Logging is enabled, otherwise I would not get any rows in the log table (as I said, the error is there, but the description...

I think this is SQL Server 2005 only, to Quote from SQL Server 2000 BOL:

varchar[(n)]

Variable-length non-Unicode character data with length of n bytes. n must be a value from 1...

Oh yeah, I forgot about that ... D`OH

If all the mappings are the same (IE if H:, or whatever, always evaluates to the same full path on all the PCs) then neither server agent nor DTSs should have...

This has annoyed me too, on some systems it remembers these settings and on others it seems to lose them. I think it has to do with the MMC (microsoft...

Not sure if it is the same in 2005 but in SQL Server 2000 you use the server network utility (which you can get to from the start menu items...

Ooooh this sounds familiar, bells going off all over the place, I`m sure Ive had this same error

Its the bit 'When i try...

A Timestamp column is 8 Bytes, so you should be able to copy it into a BINARY(8) column, remember that it will no longer be guaranteed unique though.

I have not...

We appear to be going around in circles

Look, in any installation you have to have some point at which you set up the...

If the INI file is always in the same location relative to the application calling it then ajays suggestion makes sense.

If you do store the path in a table...

Quick and dirty fix:

DECLARE @Word varchar(5)

DECLARE @MyValue as bit

SET @Word = 'True'

select @MyValue = CASE @Word WHEN 'true' THEN 1 ELSE 0 END

Is IP.SB_INVOICE_PRINT_INV_NO varchar? Could it have trailing or leading white space that make it non-distinct despite looking the same?

If you are talking about DTSs in particular did you know you can pass in parameters to a DTS when called from a command line? Look up the dtsRun utility...

Did you have a comment in the SQL? I have noticed that parameters don`t work where there are comments in the SQL

OK, that makes sense, I work in the financial sector and company names are always changing

Even without splitting the table I would still keep a...