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

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. 

SSIS error - has lineage ID 8828 that was not previously used in the Data Flow task - - -VS_NEEDSNEWMETADATA

SSIS error -  has lineage ID 8828 that was not previously used in the Data Flow task - - -VS_NEEDSNEWMETADATA


To resolve the above error

This happens when there is a change in the SQL server Schema design and your meta data in SSIS package becomes outdated or recently any changes has been applied. You can open the Data Source in your Data Flow Task and save it without any manual changes. Editor will report the issue if there is any and you can update the source appropriately and consequently the transformation as well.

Or
If the code is outdated and the dataflow task source or any task content is changed then this error occurs. To resolve this, double click on each of the task that has this error. You should get an option of "Do you fix the metadata....issues automatically..." Click on Yes. Your error should go away.

If your error is still not fixed then recreate each of the tasks and execute it to make the code work. 

The external columns for component "OLE_SRC Get are out of synchronization with the data source columns.

The external columns for component "OLE_SRC Get Transactions" (187) are out of synchronization with the data source columns. The external column "TotalSalesUnits" needs to be updated.
The external column "TotalSalesValue" needs to be updated.


To resolve the above error Set the ValidateExternalMetadata property for the task to False

[OLE DB Destination [761]] Warning: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

[OLE DB Destination [761]] Warning: Cannot retrieve the column code page info from the OLE DB provider.  If the component supports the "DefaultCodePage" property, the code page from that property will be used.  Change the value of the property if the current string code page values are incorrect.  If the component does not support the property, the code page from the component's locale ID will be used.



To resolve this error perform the below steps

1. Double click on the Data flow task

2. Right Click on the OLE DB SOurce data flow task.  

3. Then go to the properties tab and set the AlwaysUseDefaultCodePage peoprty to True.

Apply Page number to MS Power Point Presentations to all slides

Hi Folks,
Below are the steps to add slide numbers, page numbers, or the date and time

1. On the View tab, in the Presentation Views group, click Normal.
2. On the left of your screen, on the pane that contains the Outline and Slides tabs, click the Slides tab, and then click the first slide thumbnail in your presentation.
3. On the Insert tab, in the Text group, click Slide Number.

4. In the Header and Footer dialog box, do one of the following:
• If you want to add slide numbers, click the Slide tab, and then select the Slide number check box.
• If you want to add notes page numbers, click the Notes and Handouts tab, and then select the Page number check box.
5. If you want to add numbers to all of the slides or notes pages in your presentation, click Apply to All.
6. If you want to change the starting slide number, do the following:

1. On the Design tab, in the Page Setup group, click Page Setup.
2. In the Number slides from box, enter the number that you want to to print on the first slide or notes page, with subsequent slides numbered.

Change font of all slides in MS Power Point (ppt)

Hi Folks,
Below are the steps used to change fonts for Power Point Presentations

1. On the View menu, point to Master, and then click Slide Master.

In master view, thumbnails of each slide master appear at the left. Some slide masters are paired with a title master.

2. Working on one master at a time, select the thumbnail for each slide master or title master for which you want to change default fonts.
3. On the master, click the text level for which you want to apply a new default font.

Remember that when you are working on the master, you are changing only the font and not the text content.

4. On the Formatting toolbar, select a font in the Font box .

 TIP   If you want to apply other types of font formatting, such as size, bold or italic style, and color: On theFormat menu, click Font.

5. Repeat these steps for any other text levels for which you want to change the default font.
6. To return to normal slide view, click Close Master View on the Slide Master View toolbar.

 NOTES 

• If some of the fonts on your slides do not reflect the new defaults, other font changes may have been made on individual slides before you changed the slide master. Microsoft PowerPoint always preserves changes that are made to individual slides. To correct this problem: Display each slide in normal view. On the Format menu, clickSlide Layout. Right-click the thumbnail of the layout that the slide uses, and then click Reapply Layout on the shortcut menu.
• If you want to replace every instance of one font with a different font throughout an entire presentation: On theFormat menu, click Replace Fonts. In the Replace box, select the font that you want to replace. In the Withbox, select the font that you want to use as the replacement, and then click Replace.