We ran into a major issue with Integration Services, which caused us a major scare, so I wanted to share it. We had a query, which was pulling out a list of items to compare to determine what to load. This list was generated with a simple query, where the date was calculated like this: … Continue reading →

We have a scenario where we need a dynamic pivot table from SQL data. I’m going to try and make this generic, so if there is confusion, please let me know. The scenario: We have a parent database and a child database. The child database has “attributes” for the parent database with values. SQL to … Continue reading →