get an error in sql server when i put that in.

also still have same error in ssis dont no whats going on so

no error at all in sql server

get the same error in ssis package

hi

ya still get error with the single quotes on all line

INSERT INTO [dbo].[SSISLog]

([EventType]

...

ya have it like that in my ssis package and get the same error

[Execute SQL Task] Error: Executing the query "INSERT INTO [dbo].[SSISLog]

...

keep getting this error

[Execute SQL Task] Error: Executing the query "INSERT INTO [dbo].[SSISLog]

([EventType..." failed with the following error: "Conversion...

hi

thanks for reply it will be going into an ssis package

so does it go in like this

INSERT INTO [dbo].[SSISLog]

...

if i did my select like this

select MIDIRB,

IRBT.ID as IRBT_ID,

IRBT.IRBRATING as IRBT_IRBRATING,

ACRT.NEGWATCH as ACRT_NEGWATCH,

case when ACRT.NEGWATCH = 1 then (SELECT IRBT.IRBRATING FROM IRBT I WHERE I.ID = (IRBT.ID +1))...

ok thanks will try that

still getting this error

Msg 208, Level 16, State 1, Line 1

Invalid object name 'IRBT2'.

thanks for response will try that

hi

out of interest is it possible to do it this way

update ACRT set MIDIRB = min(IRBT2.IRBRATING)

from ACRT,IRBT,IRBT2 where ACRT.MIDIRB = IRBT.IRBRATING

and IRBT2.IRBRATING > IRBT.IRBRATING

and if so what do i...

thanks very much for help will try that

and also will try improve my [post in future

again thanks

ya just double checked there and its ordered on the irbrating

hi

i think i just put them in to quick to get a reply.

they are odrered on the number from the irbt table.

so 2- 25 in that oder

2

3

4

5 etc