A quick Google search led me here[/url]. I'm sure that you can find others.

I think that you can do it using catalog.set_execution_property_override_value.

Kishore M. K. (2/18/2016)

---

Thanks Beatrix Kiddo and GilaMonster for sharing these valuable information with me.

Phil Parkin, thanks for your suggestion. Will do take care of writing a question next time.

Also,...

Sounds like your current place of work is not where you want to be.

Decide on what sort of position you would like next and then get your CV up...

Stephanie Giovannini (2/18/2016)

---

Apparently VS 2013 (SSDT 2014) still uses VS 2012 for scripts by design. So it looks like the script didn't migrate, but in reality, no migration is needed....

dndaughtery (2/18/2016)

---

Hey guys, I'm getting the following error when I try to run my package which contsins only an execute process task calling WinSCP.

Error: [Execute Process Task] Error: In Executing...

dndaughtery (2/18/2016)

---

Hey guys, I'm getting the following error when I try to run my package which contsins only an execute process task calling WinSCP.

Error: [Execute Process Task] Error: In Executing...

I've gone back to using SQL 2012 since writing the above post. However, I think it may be as simple as opening the script task for edit and then closing...

Sergiy (2/17/2016)

---

Alan.B (2/17/2016)

---

Unless UpdateDt is not unique. Then perhaps a clustered index on composite key consisting of...

SQL Monitor[/url] might be of interest, if you are prepared to spend money on a solution.

Exactly what I was thinking.

Sure, sounds easy enough. What problems are you envisaging?

JustMarie (2/17/2016)

---

I'm all for parameter tables. So that's a piece of my potential solution.

Read the parameter into a variable and then used a Derived Column transformation to get the...

What makes you think that the trigger is the problem? Maybe the update statement itself is the problem.

Rich Mechaber (2/16/2016)

---

Hi, Phil, my memory is that this was rather involved when I implemented this a few years ago. Jonathan Kehayias had a nice write-up about how to do...