I'm still having issues in connecting to an Informix database on a 64 bit server using the ado.net drivers. My SSIS package isn't able to convert nvarchar data to...

This is the update

IF @END_STEP_CODE= '133'

BEGIN

IF @START_STEP_CODE = '132'

BEGIN

UPDATE #COMPLETE

SET START_ACTUAL_COMPLETION_DATE = CASE

WHEN @START_ACTUAL_COMPLETION_DATE > @PREV_END_ACTUAL_COMPLETION_DATE THEN

@START_ACTUAL_COMPLETION_DATE

ELSE DATEADD(DD,1,@PREV_END_ACTUAL_COMPLETION_DATE)

END

FROM #COMPLETE c

WHERE

c.loan_id= @END_LOAN_ID and

c.step_code =...

My question is what would cause the DYNAMIC cursor to continue to act as a READ ONLY cursor and continue to read the tempdb resultset? I didn't see a...

Here is the temp table ddl

CREATE TABLE #complete

(LOAN_ID varchar(13),

step_code varchar(3),

start_actual_completion_date datetime,

end_actual_completion_date datetime

)

INSERT #complete

(loan_id,

step_code,

end_actual_completion_date

)

SELECT

LOAN_ID,

STEP_CODE,

ACTUAL_COMPLETION_DATE

FROM dbo.fct_foreclosure_step...

It's not so much using a cursor to do an update, but rather finding the starting record that matches the end record and finding any overlaps in the actual completion...

I'm trying to find out why the updated records are still in the fetch next of the START cursor after they RECORD_READ is set to 1. I removed the...

This did the trick

FileCount = CType(Dts.Variables("varFileCount").Value, Integer)

FileCount += 1

...

I'm getting an error that says Option Strict On disallows implicit conversions from 'Object' to 'Integer'.

How do I convert the object to an integer?

I have added the varFileCount to the readwritevariable, and I'm updating the counter using this code

...

I'm simply trying to increment the counter, but it resets to zero with each new file. I'm using the file enumerator in the foreach loop and it's just the...