It looks like a TCP endpoint could listen on multiple ports in SQL 2005. I suspect it will work in SQL 2008+, but have not tried it.

See TCP Endpoints section...

I think you would need to split the functionality if you want to use Windows Authentication for both since a process can only have one identity. If you can refactor...

You won't find it in a separate column. The property pertains to any Task within the SSIS package so you would need to look for it in the XML that...

Have you checked that the job and schedule are enabled, and that the schedule does not have an end date?

If that was for me, the bulk of the data is loaded...

Welsh Corgi (4/4/2012)

---

opc.three (3/23/2012)

---

What I often see are separate databases on the same instance, where the staging database is in simple recovery mode and the data warehouse is in full...

Gary Varga (4/4/2012)

---

Scott D. Jacobson (4/4/2012)

---

The Powershell button would be totally awesome. I clicked through to vote and it now says "voting has been closed on this item". ...

I could not agree more. PoSH is a technology Microsoft is offering up to help support all their...

Evil Kraig F (4/3/2012)

---

I agree with Elliott that you're using a best practice scenario there with what's available. For more complex decisions I'll occasionally use an asynchronous script component...

Is that to say the Server Login is the Database Owner, i.e. the dbo? If so, then...

For future reference here is what I use to track long running DML statements that affect a lot of rows. You can use it instead of the GUI steps you...

This script is much farther along, but I would still classify it as Beta. I think it properly deals with aliases and orphan logins with respect to aliases now. While...

It was a great idea...it still needs some help though so please do not use in production yet! I will post more as time allows...please do the same if you...

It is a very nice script! I like the use of the variable, instead of a cursor. I definitely just swiped this script, thanks for sharing it 😀

One thing I...

The point Craig and I are trying to drive home is: unless you have a requirement that says that a sequence of IDs cannot have any gaps in it,...