I would guess that some developer thought he could wire a better SoundEx and something was coded into a front end application that inserted the data. If I were...

Make sure you have SET NOCOUNT ON at the top of your procedure if it does more than one operation. SSIS sees the rowcount notifications and data sets and...

That is one way. I remember seeing an article on this subject recently, but I could not find it.

Usnig a GUID and a table works - and pretty well....

Error: 0xC00220DE at Execute Package Task: Error 0x80070002 while loading package file "pkgAssignCompanies". The system cannot find the file specified.

I believe this would normally display the full path of the...

Use a derived column component in your data flow. There are functions for parsing dates.

Yup - typo.

An Identity column becomes a problem because you will have a view hitting multiple databases, so to use an identity column you will have to specify an identity...

You could make a copy of the directory the data is stored in and try parsing the data file, but I think the MDX will end up being easier to...

; WITH Sales (Sales_Person, SaleID, Model, Date_Sold)

AS (

SELECT sales_person, Row_Number() OVER (Partition By Sales_Person, Model ORDER BY Date_Sold)

, Model, Date_Sold FROM MyTable

)

SELECT

S.*

, P.Date_Sold AS Prev_Date_Sold

FROM

Sales S

LEFT JOIN Sales P ON...

You can run a command line from a job step. Getting the command line to report back a failure properly and give you any useful information would require you...

Bummer, AS2005 would be more helpful because of the drillthrough architecture.

You are going to have to query the cube with a huge MDX statement that includes every dimension - or...

Huge difference. The architecture is completely different. Your problem is likely in your hierarchies. It is most likely a structural problem in your cube design.

It is not much more expensive to have cross-database joins. It complicates security a bit. If you are to do this, I would suggest using synonyms to facilitate...

A GUID is only unique to that computer if it does not have a NIC. So, two machines without NIC cards can generate the same GUID relatively easily.

If it...

Setting this up is really not that complex. distributed partitioned views can replace a table relatively easily. You will not take a performance hit using views to access...

This is a Master Data Management question and the answer will depend on a lot of variables. Hopefully, we can help you ask the right questions.

The use of a...