chris.j.clague (6/13/2012)

---

Really, staging table and a merge statement is all you need (2008+). For 2005 I'd just use a proc to replicate the functionality of the merge statement. SSIS is...

ako58 (6/13/2012)

---

The DAC port is assigned dynamically by SQL Server during startup. When connecting to the default instance, the DAC avoids using a SQL Server Resolution Protocol (SSRP) request to...

Samuel Vella (6/13/2012)

---

Koen Verbeeck (6/13/2012)

---

Just reading files, derived columns and saving them to another file? So no blocking transformations in your package?

It seems odd BIDS needs 1.5Gb for that. On...

Just reading files, derived columns and saving them to another file? So no blocking transformations in your package?

It seems odd BIDS needs 1.5Gb for that. On the other hand, I'm...

SSRS uses caching to speed up report execution. My guess is that you're always working on the cache and thus seeing the same results.

There are some files you can delete...

You can also use a derived column component to add new columns with static values.

But in my opinion, Craig's solution is the most straightforward.

Good remark. The admin could have specified the non-default port...

I'm not on my machine with SQL Server 2012 right now, but I can remember you can configure the environment in the SQL Server Agent jobstep. Quite similar on how...

I don't think it is possible to reference packages outside the project without using file connections.

It would be nice if they added such functionality though.

When you link your project to an environment variable, you need to choose one before you start the package. It will not take one by default. It's up to you...

Another question:

you claim the following:

About how much volume are we speaking here?

It seems to me that for very large volumes the FULL OUTER JOIN...

So it can be different, but there is no indication that it will be?

So there is a chance DAC will succeed for the default instance as it tries port 1434...

Are you using configurations at some point?

Nice question.

The MSDN article Using a Dedicated Administrator Connection says the following:

SQL Server listens for the DAC on TCP port 1434 if available or a TCP port dynamically assigned upon...

A had a quick glance through the article. The title says it's about CDC, but I don't see anything about the change data capture functionality introduced in SQL Server 2008....