I learn as the need presents itself. I stepped out of IT development at my former place of employment and took on an operations supervisor role for almost five...

Thanks! And yes, it works

I already did change the type of @WeekDay to be varchar (not date)

Thanks for this! This does start me all in the direction I need to go.

Thanks. It is 2008R2 (as to why I am posting here in SQL Server 2008). I did some searching online and have something actually running now so now...

Also, something I thought about that did "flatten" this file is opening the XML with Excel. I can then use the Excel file in SSIS. Wondering now if...

I do have the XSD (schema) for the XML file and that is indeed what I based the tables on. It is here.

<?xml version="1.0"?>

<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:element...

Thanks Alan for the reply and yes, I did not mean XLS file (not an excel file), but an XML transformation. Simplistically, here is the schema:

<response>

<client ID=""...

This past summer I left a job at a major food manufacturing corporation to work for a governmental agency non-profit and took a $20-25K per year pay cut. But...

Thanks and yes, it does help some. But here is what I need to figure out now. Using your example, the reporting department here needs to see some...

Just to clarify, I'm hoping that you've included the effective dates and current indicator in your dimension table...not your fact table. These attributes should then be used to determine the...

Thanks and you have been a tremendous help. Although due to other projects on my plate, I will not be able to revisit this one until tomorrow morning, but...

Thanks guys for the information (I marked both answers as solutions) The business here determined to go with the latest historical data for the time period they are running....

This is great advice that I will share with my small team of SQL Server developers I work with. I usually give them some daily technical inspiration and this...

My thinking is that years ago, data integrity was not as important as people are realizing it is today. I am just finishing up a data mining class and...