Wrote this for a client years ago, still running today.

Couple of tips:
1.) Handle the parameters and extension settings as the whole XML BLOB; don't chunk it up. ...

EXCEPT is awesome for Row Differences between 2 sets, but I would caution that if you have a pk (like maybe in comparing objects between a publisher and subscriber in...

Nice article Ira, kinda familiar too. 🙂

JOEL-145858, don't take the content of the article out of context. This is one of MANY methods that you can use in matching,...

Yeah, I've been through this POC before and what I've discovered is that even if you have the Google Maps Premier license, you still can't use it for this sort...

Well, I guess it all depends on how well the infrastructure is defined. Let's say I have 3 app specific DB and three environments:

App1

Dev -...

I totally agree opc.three; I guess it depends on why you need to change the Connection. If your looking at it from an infrastructure perspective, and it's to make...

Glad I could help...most of the properties of almost EVERYTHING can be configured by variable or expression in SSIS Packages

Disabling all logins may be a little extreme... Depending on how you're refreshing you might be able to switch in and out of single-user mode to block access to everything...

The easy way to switch it at run-time is through variables:

1.) Statically build the connection manager you require (OLE DB, FlatFile, Whatever)

2.) Build package-level variables to hold things like ServerName...

alen teplitsky (11/9/2010)

---

GilaMonster (11/9/2010)

---

Joshua T. Lewis-378876 (11/9/2010)

---

Simon,

Just as an FYI, Microsoft has depreciated the TRUNCATE_ONLY option in SQL 2008, and you have to use a different option in the BACKUP...

Simon Facer (11/9/2010)

---

Joshua T. Lewis-378876 (11/9/2010)

---

In an effort to curb the necessity of shrinking, I have always taken a few steps whenever setting up a DB:

3.) Build two ldf files...

Simon,

Just as an FYI, Microsoft has depreciated the TRUNCATE_ONLY option in SQL 2008, and you have to use a different option in the BACKUP LOG command:

BACKUP LOG <database> TO DISK='NUL:'

There...

In an effort to curb the necessity of shrinking, I have always taken a few steps whenever setting up a DB:

1.) Always separate by partition (or even physical disk...

David, really enjoyed seeing how you've implemented this and you couldn't have had better timing, as I am currently developing a GeoCoding solution; but for the example used (Google Maps...