ok thanks guys! that helped!

oh gosh thats sounds complicated. I can do a loop in my client application that does the matching instead

onces the uniqueidentifier is then extracted and handled as varchar.

thats right, users.userid is of datatype UNIQUEIDENTIFIER,

when I use a cast I get

cast(Users.UserId.id as varchar(100))

Cannot call methods on uniqueidentifier.

Users

-------

Email (VARCHAR)

UserID (UNIQUEIDENTIFIER)

...

it worked with substr(xxxx,1,20) but as soon

as I did substr(xxxx,1,80) it failed with truncation....

I narrowed it down to be between substr(xxxx,1,45) that works

but substr(xxxx,1,49) that failes. What on...

Hello dwithroder, well dropping by substring does not solve the issue. I

introduced that to get around it but did not help.

I also introduced some error handling.

If I set the...

Hi Tim,

I cracked down on the validation. I am using a for loop in ssis to loop through years like 2000 +1, 2001+1, 2002+1 < 2003.

Each year has about 50...

I just executed my package but the validation time is taking ages....running since 9 minutes validating

my data flow task.

Hi Old Hand,

Unfortunately I cant install the 11g client or any third party tools (it department and licensing is an issue).

I have to stick with to my ssis standard components...

Looking since a few hours into the issue now and discovered a statement made on infoqu.com that

this might be with incorrect table definition of the oracle destination table (i.e. field...

I tired increasing the buffer size which made the transfer run to up to 99670 rows out of 700 000. (before buffer doubling 96560). but it still does not make...

thanks guys. that did the trick.

I will try open office draw

that fixed it "AND @OldValue IS NOT NULL"

DECLARE @OldValue VARCHAR(50), @F2 VARCHAR(50), @ID int

DECLARE product_cursor CURSOR LOCAL

FOR

SELECT tempID, F2 FROM dbo.Products ORDER BY tempID

OPEN product_cursor

FETCH NEXT FROM product_cursor INTO...

Hi SSCertifiable,

thanks for the code.

THe issue is that somehow that my table looks like this:

[F2]

Car1

Car1

Car1

Car1

Car2

Car1

Car1

Car1

Car1

Car1

Car1

Car1

Car3

Car1

Car4

Car1

Car1

Car1

Car1

Car1

Car1

Car1

Car1

it seems like the cursor has fetched "Car1" and inserted it wherever there is a NULL

value...