I have seen 3 movies nominated for an Oscar -- Moneyball, Midnight in Paris and The Help. I would recommend seeing all 3 of them, but I just like...

For each iteration of the FEL? Or does it open one connection? Thanks.

Thanks for the follow-up, guys.

Nice article...thanks!

What's the implication of opening the connection each time in the FEL? Or is SSIS smart enough to keep the single connection open for the duration of the...

Along the same lines is to take a break from a particular problem, if you are stuck. I can't tell you how many times I have gone home, and,...

Ha, ha, ha! "...warm and cuddly...". I like that.

I was going to say "rude", but I choose the word "abrasive" instead.

I am all for learning, and for helping...

Man, kind of abrasive, no, Mr. Celko?! I thought that this is supposed to be a supportive forum. I can understand your frustrations, but we can direct people...

Thanks for posting the article.

I think that everyone is mis-understanding. It is not a fully-flushed out implementation, but, as the author mentioned, only to be used for a proof-of-concept,...

There is also a nice 3rd party tool from RedGate (SQL Search, I believe) that can help you with this.

Thanks...Chris

Thanks for the article.

To use shared templates, we overwrite the existing templates, whichever ones we want/need, with ours. We distributed a batch file to perform this action.

Thanks...Chris

Did you see my post?

- Chris

You can include VB.Net or C# code in an SSIS package using a Script task. So, you could take the code from your VB.Net app and add it in...

Check this link.

http://blogs.msdn.com/b/mattm/archive/2008/08/22/accessing-oledb-connection-managers-in-a-script.aspx

Hope that it helps.

Thanks...Chris

Don't worry, everyone...I did not have to kill Jeff. 🙂

Hi, Jeff. Sorry, but I cannot talk about it all. However, one use would be for the common goal of organizational structure.

Thanks...Chris