Thanks Jim! it looks like excel was caching like you said. I checked the connection string first thing before posting here and that was the only thing I knew to...

For future users who are searching for the same solution, I found another feed at the link below which discusses the exact problem I am working:

http://www.sqlservercentral.com/Forums/Topic839545-147-1.aspx

Thanks John,

Thats what I was thinking. I am just not very familiar with SSIS and am in need of something like yesterday... Ok well looks like I am going to...

Thanks for the quick response. I fully agree with that approach however, I cannot alter the application... I could make the field required but there is no place for the...

So it's been a little while and wanted to post again to push it to the top section of the forum. If anyone has any ideas, that would be very...

Jeff,

Thanks for the reply! I am working on the tables for the SOD ruleset for comparison. However, I am looking to build something that will facilitate a population user...

Good point dwain. Can you post up those alternatives and the performance considerations for node traversal? (Or a link to other posts discussing these related topics)

I HAVE FOUND THE ANSWER! Wish I could take credit for figuring it out myself but sadly I cannot. The link below has a great explanation for these types of...

Awesome, thanks Markus. I will check that out

Great article! I will be following this feed to the end. The attention to technical detail and practical steps are great and help new comer's like me to work my...