Amazing replies! Thank you both so much, I’ll work through both examples so that I understand the logic behind them. You’ve made my day tomorrow a lot better 😉 Thanks...

Thank you both for your answers, I wasn't thinking outside of the box.

Thanks for your replies. Since my last post i have been tryin gall sorts of things and have got a few new errors but i think they are the last...

Hi,

The c_achieve is a varchar 100 null in both source and destination table. I went to the meta data by doing what you instructed and I copied the data to...

Ok, after some playing i have got more detailed errors out of this deadlock. I tyhink they are different from before, i am posting them now and am also going...

Thanks, no it does not reference the destination table.

I can see lot's of carrige returns in the source data, i wonder if that is causing me issues?

Hi I just posted a message and your came in at the same time. I'm not sure i understand the question, I have two connection one to the view and...

Bearing in mind i have an ssis package. I have just found this command that i have ran on the destination server in the query window DBCC TRACEON(1204, 1224, 3605,...

Hi, Thanks for that.

I am not familiar with the necessary tasks to setup the trace flag and get the deadlock graphs? I guess I’ll be googling that, please inform...

Hi, I managed to get some errors writting to the logs and wondered if anyone could give me some help with them. There are a few 🙁

Thanks

#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message

PackageStart,CRM,CRM\Administrator,Package,{32833F60-011C-44C1-AE01-DE591DC521B8},{AE9C75BA-F1C0-46E3-9BE6-BE14E2606778},10/02/2011 16:43:10,10/02/2011 16:43:10,0,0x,Beginning...

Thanks for your replies.

I have just right clicked on the arrow joining the source and destination and can see the data viewer, after a while i can see the...

That was just what i needed.

Thanks for all the help, one more quick thing. Those big functions what senario would you use those in?

Thanks again

It's not a view, it's a real table in my SQL Express 2008 database.

I nearly missed that post, i tried the following but it generates an error. Any thoughts?

update dbo.wce_contact set firstname = dbo.ProperCase(firstname)

Error:

Msg 1014, Level 15, State 1, Line 1

TOP clause contains...

I did try replacing all the instances of @OriginalText and put in the field name contact but i get the following errors:

CREATE FUNCTION ProperCase(contact)

RETURNS VARCHAR(8000)

BEGIN

DECLARE @CleanedText VARCHAR(8000)...