I know it was not CTE or TDE. But, I might have misheard and it was CDC. I am not familiar with CDC as well 😀

Thanks Steve. But it looks like creating the SSIS package through the importa data wizard works better and can be reused too.

Could you please explain how does that work? I am not familiar with access.

Thanks Brandie.

I think i need to go with the option 1. But I am curious about the hidden ansi character. Would you please explain what is ansi hidden character and...

That exactly what I was looking for. Thanks Ninja's_RGR'us for your quick response and time.

As this one is solved I came up with the other issue 😀 ....

I just want to avoid the rows affected message on the text file generated by the query. But set nocount on remove the rows affected message in SSMS but doen't...

Paul,

I am sorry, I couldnt make it clear. I just need to find out the item which has different value. But, i don't want to touch the item which has...

Thanks a lot Jim. It did work exactly as expected.

Thanks a lot again

W.