This is not what I had planned but it worked!

Thanks Luis 😀

Ignore this post please.

Yup!!! Was missing the COLLATE.

Update TABLE

set DS = Replace(DS, nchar(65533) COLLATE Latin1_General_BIN2, '!')

Thank you all very much! I love this site :-):-)

Ok, so here is what I am trying to do but it is not working. Any ideas?

UPDATE TABLE

SET DS = REPLACE(DS,NCHAR(65533),'');

Awesome! Thank you very much for making my Friday :-D:-D

What I mean by cash-cow is that they rarely make significant changes to the product and push to release new versions. SSIS is not free as it is included in...

I found it! There was this weird character (?) in the data, so you are right about SSIS.

Thanks!

Good point about the Alter Table script. I was able to dump the data into a table with all NVARCHAR datatypes and then was easily able to push the data...

I'll check it out, thanks for your feedback.

On a side note... I am very surprised that SSIS is still (after all these years) one of the worst ETL tools...

Thanks for your response. I figured that was the case but just wanted to be sure.

BTW: Your signature is hysterical! I love it! Both cynical and logical 🙂

Thank you for your advice. I will go with the second loop as there is no performance hit. Plus I will only have to archive around 30 - 40 files...

Nice Luis! Fast as hell too!

Much appreciated 😀

Ok, figured it out....

You have to go to the data sources and reconfigure the security options. Inherit, Impersonate User, etc did not work, but when I typed in my full...

OK I found it....

Basically you go to add/remove programs and select remove on the SQL 2012 instance. You will then go through the steps and select what you want to...

Thanks guys! I appreciate the feedback.