Hi Grant, that's really kind thanks. What format would you prefer the plan in? Text in an Excel file?

Cheers,

Dave

Hi Dino, thanks for the reply.

I actually ended up simplifying the left outer joins as there were some casts and conversions on one of the sides. As I control both...

Hiya, thanks for the response.

i had cast the branch_key as varchar 3 in the select statement but the advanced editor was still showing 4 byte int - all fixed when...

Hi Sue, I was rather proud of that one!

Dave

Hi Dan, you are right, words do matter.

Personally I took no offence from the OPs words but I fully understand if you and others are offended and I support your...

Hi Dan, yeah you are right however I think the OP was trying to provoke a reaction from us rather than offend us. In my opinion, he wants us to...

Hi Steve, I 100% agree and also despite using SQL server daily for BI development and data warehousing, I include myself.

I just sent the below email to my colleagues as...

Hi, thanks for this. I have set up a #tmp table that has 1 row 1 column and as an initial step I write the variable value to that table...

Hi, just be careful that you aren’t missing different errors on files that are actually present. Do you have some sort of audit table/ process that logs the outcome of...

Hi, this works for me when I want to be selective with files.

https://stackoverflow.com/questions/6598139/how-to-loop-only-through-files-that-dont-exist-in-destination-using-an-ssis-pac

Dave

Because...

Hi thanks for this. I will give it a go.

Cheers,

Dsve