I showed that to the sys admin and he gave it a try but we didn't have any luck with it.

Sue - Thank you!  I was able to get it to work using both NET START MSSQL$<instancename> /f /T3608 /mSQLCMD and .\sqlservr.exe -c -m "SQLCMD" -S <instancename>

As a...

After no luck finding meaningful error messages or finding information online, I decided to tear into the registry. It's important to note that I did also change the structure and...

sevensinz and Phil - Both are good points.  I think I'm trying to get too creative when there are simpler solutions that work just as well, if not better, than...

Thanks for all of the pointers.  It seems as though my design isn't the issue which is good.  I was following along with another thread on this board about someone...

No, it won't be every combination.  Just trying to tie together fields that are part of three separate lookup tables. So for example if the Name in the source is...

The partial example I included doesn't get into updating.  It is only for new records and, therefore, requires an insert.  Hopefully in an attempt to make better sense picture it...

The issue I'm having is fully populating the dimension.  I'm using SSIS as my ETL tool and here's the incomplete part of what I'm visualizing. 

Each record would...

Thanks, Ivan! That did the trick.  I stumbled across that prior to posting but I was reluctant to try because 1.) the name is quite scary and 2.) the article...

Thanks for the feedback.  It's been great help!

Steve - I get what you are saying now.  Here I thought I was doing the analysts a favor by eliminating what seemed to be duplicate data.  I was essentially...

I can't say I've ever had to use them.  However, it seems to do what I need it to upon a quick glance.  I will definitely look into what each...

What are you looking for when you say after I post my actual query?  I'm using the fuzzy lookup transformation within SSIS to do the matching and generate the output...

Thanks, Igor!

I'm running the same exact query and only getting an error message with the linked server so that's why I believe it has something to do with that.

I...