To get all inserted or updated members from a SQL Server MDS database, subscription views are … Get Inserted, Updated and Deleted members from MDSRead more
Year: 2014
Running an MapForce mapping from SSIS
In an earlier blog post I demonstrated how to map between hierarchical (XML) and relational (SQL) … Running an MapForce mapping from SSISRead more
Using MapForce to insert hierarchical XML to relational tables
In an earlier blog post, I demonstrated a way to insert a hierarchical XML document into … Using MapForce to insert hierarchical XML to relational tablesRead more
Max or min value from a set of columns
The min and max aggregates in SQL Server are normally used to work over rows, getting … Max or min value from a set of columnsRead more
Default collation different from instance default
If you have databases with another default collation than the instance default, you may get something … Default collation different from instance defaultRead more
Error 3624 when creating natively compiled stored procedure
I was trying to upgrade my MACD technical analysis calculation to use the new In Memory … Error 3624 when creating natively compiled stored procedureRead more
Sorted data flows in SSIS
Sometimes a data flow in SSIS needs to be sorted. It may be because the business … Sorted data flows in SSISRead more
Add missing lookup in SSIS
Before a fact table is loaded, a common pattern is to do a lookup in SSIS … Add missing lookup in SSISRead more
T-SQL function SERVERPROPERTY
The T-SQL function SERVERPROPERTY returns a lot of properties about the current SQL Server instance. The … T-SQL function SERVERPROPERTYRead more
Table Valued Parameters in Stored Procedures
In most cases stored procedures are developed so that it accepts a number of input parameters … Table Valued Parameters in Stored ProceduresRead more