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.

Drag and drop will not work in SSAS Cube

Hi,

Today my trainees faced a strange issue, they were trying to drag and drop the deployed dimensional attribute in the cube browser and they were not able to do so. They also tried to right click on the attribute name and click on "Add to row" but it would fail.

To resolve this issue, I checked the server to which thier cubes were connected, i,e the Analysis services server. It was disconnected. when I reconnected it and asked my trainees to redploy, reconnecr and refresh, they were able to drag and drop attributes like before

SSAS - Grand total value is repeating or it is the same for every measure value

Hi,
I was teaching MSBI to my trainees and I noticed that the in the cube browser the Grand total value is repeating for all its measure values as shown in the below picture.

To resolve this error check your dimension structure under "Cube Structure" tab. Check if the dimension you are dragging and droping is diretly related to your fact table. If not then establish the relationship by clicking on "Dimension Usage" tab. I added the referenced relationship and bingo, it worked

Not getting unique values in Hierarchies - in dimension browser

Hi,
I was trying to create the DIM Geography using listed in Adventures Works DW and when I deploy this the browser will show me so many Country names as shown in the below screenshot

After worrying my head a lot on this issue, I realised that this happened as I had set key column even for EnglishCountryRegion name. Hence to resolve this issue, I came back to "Dimension Structure" tab>right click on "English Country Region Name">Click on properties>Come to "Keycolumn" and remove any other attributes added and make the EnglishCountryRegionName to be uinque. Check the below fig

 Deploy and then reconnect to get the final result

Trust relationship between the primary domain and trusted domain failed in analysis services

Hi,
I was teaching MSBI to my collegues and I could not make them deploy thier analysis services project on my server. I figured that I have to add thier names as admin and when I tried to do it, I get the above listed error message. To resolve this error message follow the below steps:

Right click on Analysis services server name >Click on Properties
Click on Security tab at the bottom.
If you are getting this error message then you should see the below screen

Delete the entry highlighted in yellow.
Now you would have lost your admin rights too..so quickly enter your login details to gain the admin rights . i,e click on ADD and then enter your own login details

Now continue adding other admin details

Bingo!!...It's working

Error: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully.

Hi Folks,
I had new version of VS 2008 R2 installed. I tried to do my script task in VS. And  I was so dissapointed to get the below error message

"biError: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully."


But I managed to resolve this issue :)

If you are using 2008 or later you can try the below steps

Set the DelayValidation field to "TRUE"

This error happens if you have made wrong changes to the script task code. Copy paste your existing code to a notepad, get a new script task in your control flow and edit it in a way that you dont delete much from this new script task


If you are using 2005 you can try the below steps

Install hotfix from the below link

http://support.microsoft.com/kb/932557

Set the Precompile property under the scripttask property as True