Useful CMD tips

Space Problem in CMD

Pass a path with space to a batch file as a parameter

How to run a “.bat” file during installation?

SSRS - By pass specific user to Reporting Server

When we browse to Reporting Server, it usually ask a username and password to access. However, sometime we want to avoid that by using specific account (treat like webapp that know db password). To do that we have to implement a custom web application that host a web page which can load ReportViewer. Then that page have to specifically implement parameter specification before by pass its parameters to ReportViewer control. The steps are shown below:

By pass anonymous access for reports using custom web app as a proxy

1. Create ReportViewer in custom web app
2. Using the WebForms ReportViewer Control
3. Set credentials for ReportViewer
4. Set Report Parameters with Credential

Create self WCF Windows Service

Check out these links, it help me a lot to allow me creating self WCF and installed it as Windows Service.

Walkthrough: Creating a Windows Service Application in the Component Designer

Automatically start a Windows Service on install

How to run a “.bat” file during installation?

Call JSON in WCF

Custom Behavior in web.config

Enable CORS in WCF

1. Converting WCF CORS restful service from .Net 4.5 to 3.5 causes preflight request to break
2. Implementing CORS support in WCF
3. http://stackoverflow.com/questions/8854137/i-have-implemented-afterreceiverequest-method-from-idispatchmessageinspector-a
4. AJAX JQuery SelfHost WCF -> ByPassCrossDomain Method
5. Implementing CORS support in WCF

SSIS - Parameter things

In SQL Server Integration Services, sometime we have to use the values that can be varied on circumstances e.g. parameter. For my frequent cases, there are 2 cases listed below:

1. SSIS Variables Object - read from DB
2. Map Query Parameters to Variables in an Execute SQL Task

These links explain how to load parameter which values are from database, and how to use parater into SQL query task.