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

It's certainly related...

Perhaps the author of the DLL can help you.

Dilipghimire2 (2/15/2016)

---

I got "Unexpected Termination"- Error while using SQL server 2012 to run those deployed package.

Those package include OLDEB Source and PDW destination. FYI: I created those...

pharmkittie (2/15/2016)

---

Thanks Phil, but where is the example? I do have a foreach loop that dynamically changes to connect in turn to each Access db's filename. The table...

There are a lot of resources and articles already written about this (here, for example).

Assuming that you are familiar with the tools available to you, can you be more specific...

An alternative approach is to loop round the tables, whatever they are called, using a foreach loop. Here is an example.

mw112009 (2/12/2016)

---

Reply to Post #1760966 from Lynn

The answer is "YES" ( I mean I am able to modify the code )

Why do I need the code ?

I have to copy...

Hugo Kornelis (2/12/2016)

---

Heh!...

Grumpy DBA (2/12/2016)

---

"Give a man a fish and he eats for a day. Teach a man how to fish and he eats for a lifetime."

I believe Brandie was trying...

It's helpful in that it proves that this is purely a...

scotdg (2/12/2016)

---

Thanks for the link.

My inexperience may show here with my questions/responses but in response to the options presented in that kb article:

I am not really sure how the proxy...

General Relativity, to be more precise :w00t: