Attempting to Parameterise a SQL Server 2012 Master Data Services process RRS feed

  • General discussion

  • Hi,

    I am attempting to parameterise a SQL Server 2012 Master Data Services process. I am quite new to MDS but experienced with T - SQL / SSIS.

    So I need to create a parameter for each period for example, so instead of having WHERE period = 'P1' I need to do the MDS equivalent of WHERE period = @myperiod, etc.

    Any constructive help would be appreciated.

    Kind Regards,


    Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Wednesday, April 9, 2014 8:20 AM