chholm (12/9/2013)

---

That's because I've only told you part of the story. This is part of a converting project. I'm moving all of the data from one database to another, but...

Confusing - yes it is! 🙂

OK, I won't spend any more time on the T-SQL side. But I haven't quite finished.

Your FieldB in TableA appears to be an FK to...

chholm (12/9/2013)

---

Hi Phil.

Thanks for instructing on how to make a good post. My apologies for using your time to making my post better. I've corrected and validated your code as...

As you're new here, I have been generous and done some set-up coding for you. In future, please see the link in my signature for an excellent article on how...

Nice work, well done.

I have in the past seen cases where there...

OK, so now your table is created and exists in the form you want - and you want to insert any new rows from source, or update those with new...

Also, setting the default (design-time) value of the variable to be a valid query may help you get over this hurdle.

At what point did you receive the error? (Run time or design time.)

Have you made any modifications to the DelayValidation property?

If I assume that you could do this if you knew the names of the columns, the problem reduces to getting the names of the columns and then assembling them...

Is this a blog entry, or do...

stanteitelbaum (12/4/2013)

---

Hi. We run 2012 enterprise with vs2010. I have inherited a w7 machine whose vs 2010 installation seems to have all the SSIS tool box items but...

sqlnaive (12/4/2013)

---

Twin/Koen, It was a typo. It's infact dstx. I was just cleaning the official info from the logs....

Have you got...

You'd already written 99% of the required query:

MERGE dbo.tblcustomerTarget AS dd...