Friday, 21 March 2014

Add 2 labels to a bar chart or stacked chart in SSRS or add a label at the middle in the Bar chart

Hi Folks!

As soon as I came to office, I got a call from my collegue to make some changes to the allready existing report. 1 such change was to add a data label at the center of the bar chart. I performed the below steps to make it work. Enjoy charting !!!


https://www.youtube.com/watch?v=c7qDBWVAymE&feature=youtu.be



https://www.youtube.com/watch?v=c7qDBWVAymE&feature=youtu.be

Wednesday, 5 March 2014

Connect to SAP source and Destination from SSIS

To connect to SAP Source and destination you will first need to download Microsoft SQL server 2008 Service Pack 2 Feature Pack from the below link

http://www.microsoft.com/en-in/download/details.aspx?id=6375

Click on Download and try to download SAP related file only (to avoid time consumption). Later run this file. After installing, open SSIS project in BIDS. Click on Tools> Choose Toolbar options and then under SSIS data flow objects you will find SAP BI destination and SAP BI Source. You can now proceed to connect to. You will also fine the SAP BI connection manager in the Connection manager window in SSIS.