abhas (12/10/2013)

---

Hi All,

I am siply loading and updating data from one table to another.But data is huge and number of column are also high. So i want to drop index...

No problem, happy to help - thanks for posting back.

I agree with John's diagnosis.

If you have multiple paths to a component and you want that component to fire when only one of those paths has successfully completed, you...

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...