Just so I am clear on this.

Overtime is Murder if you are not compensated fairly. However, Overtime is simply Killing you if you are compensated.

Does Overtime float like a...

I have heard of the Professional Day Pay Rate and it does seem to be tied to major financial areas like Wall Street. The rates are always high enough that...

Sean Lange (11/29/2011)

---

You can really yourself in trouble with that kind of data structure. You require in the ComputerRoom table a valid Building, Floor and Room. You do now however...

I did make a mistake in the order of the FK from Computer to Room. It should read like this:

ALTER TABLE dbo.Computer ADD FOREIGN KEY (BuildingName, FloorName, RoomName) REFERENCES dbo.Room...

I would model the three location entities with dependant relationships similar to Example #2.

The top two entities are Buildings and Computers as both are entry points to the structure.

Buildings must...

What title I use really does depend upon who is asking the question.

If I am marketing, then I am the CEO.

If I am trying to acquire work for myself, then...

Apparently I am hitting a known bug that is fixed in SQL 2008R2 SP1.

I am testing right now and I will report back when I am confident of the...

The hex character {1F} is the ASCII equivalent of the Unit Separator and is a non-printable character hence you see a small square box in the raw data. The files...

Each row ends in {0A} and uses a column separator of {1F}.

This behavior appears to be happening across the board with both my Dimension and Fact Table Loads.

I load one...

Screen Shot Attached and the error output is set to fail component

Raw Data Here:

2011050UNKNOWN

2011054WEDNESDAY

2011055THURSDAY

2011056FRIDAY

2011053TUESDAY

2011052MONDAY

2011057SATURDAY

2011051SUNDAY

Sorry, my fault in formatting.

The first set of data is the character offset. The next set of data is the Hex Values and the third set is the ASCII Values

Here...

Yes, each row ends in {0A} and uses a column separator of {1F}. I have verified the connection Manager is set for the column delimiter on the last column is...

When I open the file in a Hex editor, I do see a line feed character {0A}, but that is all.

The variable of type System.Object can have multiple fields, so the correct combination of Source/Destination works.

When the table adds an active flag, then you just adjust the SQL to...

Apparently I am a Pediatric Dentist. My kids will be thrilled to find that out.