TSQL Snippet: Split string in records
Case I have a string in TSQL and I want to split it into separate values / records. How do I do that? Solution There are a lot of split examples ava…
Search Suggest
TSQL
TSQL
Insert unknown dimension record for all dimension tables
Case I have a lot of dimension packages in SSIS that all insert a default record for unknown dimension values. It's a lot of repetitive and borin…
Create and fill Age dimension
Case Is there an easy way to create and populate an age dimension with age groups? Solution Creating an age dimension is usually done once and probab…
SSIS 2012 Data taps
Case I have a (very basic) package and want to add data taps to it in the Integration Services Catalogs. My package adding colors to a table Solution…
SSMS: Prevent saving changes that require table re-creation
Case When changing a column in a table I get this message preventing me to save the changes: Saving changes is not permitted. The changes you have ma…
SSIS Transactions with TSQL
Case A couple of months ago I did a post on Transactions in SSIS , but that solution requires enabling the windows service Microsoft Distributed Tran…
Create a GUID column in SSIS
Case How do you create a new Guid column in SSIS? Solution There is no SSIS function for that, but there are a few workarounds. A) If you already ha…
Create and fill Time dimension
Case Is there an easy way to create and populate a time(/date) dimension? Solution Creating a time dimension is usually done once and probably not in…