skroba (11/18/2014)

---

Sounds very reasonable and understandable but one question is left...

How to release orphaned Application, Exclusive, Session lock without dba interaction and without killing session itself? How release the lock...

Sickmyduck091 (11/18/2014)

---

I forgot to add that i have been running this in BIDS on the server itself. so the C:\temp\location.txt is actually on the server. The file is imported to...

I'd go as generic as possible:

"Revenue Generators"

Don,

What you're running into is a classic problem in Warehousing. I've heard it phrased as "Know the question before looking for the answer."

One of the reasons Kimball vs. Inman...

Okay, you have me confused....

Usually you stick the system databases (besides tempDB, that has its own set of rules) onto their own spindle set in self defense. Master and MSDB are a royal...

Yes, I did. Still have the old version. Nothing there, single declaration.

Ah, that. The chioces are User:: and System::. Why would I wan't to include that inside...

When the package works, and the job fails in Agent, there's only one culprit to do all of your checking against: The user just changed.

When you run in BIDS/VS, you're...

Eirikur Eiriksson (11/17/2014)

---

Quick suggestions, open the package in a text editor and search for the variable name, there should only be one deceleration with that name but you might find...

webrunner (11/17/2014)

---

For example, if session 3 has its time changed to a date that is before session 1, then as I see it, session 3 should become the new session...

Can we see your full code and the actual error message, please? There's no WHERE clause on that UPDATe so unless you're overwriting the...

Just as a point of clarification, we had a corrupted package, thus the nonconformity to expectations.

webrunner (11/17/2014)

---

This is not for a full-blown data warehouse. I just want to be able to put in place a system to pull incremental differences from the data as well...

Errr, you don't have to 'combine' them. You just use a multicolumn key. ...

There's not much, but is there any form of natural key on the incoming data? Not your identity, but maybe a 4 column combination showing a unique record or...