Any help with Fuzzy LookUp failing?

Thankyou Gianluca.

Appreciate your reply.

I'll try this approach against the live data and see how it performs?

Would be very interested to see some different ways to (better) solve this problem.

Thanks again...

Thank you Jack,

Sorry forgot to thank you for your advise, using a derived colum to format date fields from source flatfile as : 22 NOV 1980 and then casting this...

Thanks Abdallah, PMP, MCTS,

Have a solution for counting occurence of a specific character in a column/string.

Simply created a usd function with 2 paramters named @Search_For this can...

Well this is what i have done, dumped the following code (completed the create table script ofcourse) in Execute SQL task in a BIDS package. WORK S OK FOr...

OK.

BUt what if i wanted to drop & recreate a non temp table? How would i do that? is my current approach incorrect.

I am actually trying to integrate this...

sorry this didnt' work.

OBJECTPROPERTY(object_id(N'[DatabseName].[dbo].[TableStage]') , N'IsUserTable') = 1)

Msg:-

There is already an object named 'TableStage' in the database.

OBJECTPROPERTY((N'[DatabaseName].[dbo].[TableStage]') , N'IsUserTable') = 1)

nope didn't work.

Msg:-

Conversion failed when converting the nvarchar value '[DatabaseName].[dbo].[TableStage]' to data type int.

Msg 2714, Level 16, State 6, Line 2

There is already an object...

OBJECTPROPERTY((N'[DatabaseName].[dbo].[TableStage]') , N'IsUserTable') = 1)

nope didn't work.

Msg:-

Conversion failed when converting the nvarchar value '[DatabaseName].[dbo].[TableStage]' to data type int.

Msg 2714, Level 16, State 6, Line 2

There is already an object...

Hi Ramesh,

Does it matter how big the update is?

I wanna update 2 million + cloumns from one table to the other in a similar manner to your update statement. Is...

Boolean casting problem is because in the flatfile the field being converted is poulated with ""?

i have tried this and it passes through ok via deirved transform but when it...

How can i change datatypes in my flatfile Connection manager?

IN regrads to truncation by using casting etc in derived columns i have resolved my issues.

However still have casting errors...

Derived Transform is used to assign Source field with "Employee" value.

Also a derived column called Upload Date is there with the GETDATE() value plus there are few other derived...

Thanks Mate i'll give it a go.

Appreciate ur help.

Thanks, posted in haste.

Anyway, some of my problem was solved, it was clear from the outset that this a user rights issue.

so initially the step was executed under the...