Archive for category: XML

Making Your SSIS Configuration Files More Readable

15 April, 2010 (10:45) | SSIS, XML | By: Mark V

When you first create a configuration file in your Integration Services project, the XML contents of the file are just laid out in one long line. This makes reading and/or modifying this file more challenging than it needs to be. There is an easy way to format your file to alleviate this issue. In BIDS, […]

Jinkies! Passing MultiValue SSRS Parameters To Stored Procedures

5 January, 2010 (13:08) | SQL, SSRS, T-SQL, XML | By: Mark V

SQL Server Reporting Services provides a great way to allows report users to select more than one value from the available values list in parameters, creating a multivalue parameter. SSRS dynamically creates a comma separated list of the values selected by the user to pass in to the data source. Great. It also dynamically creates […]