Skip to main content

Search This Blog

MSBI Tutor

Top 10 reasons to choose SQL Server 2019.

Get link
Facebook
X
Pinterest
Email
Other Apps

- August 09, 2019

SQL

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You

Popular Posts

SSRS INTERVIEW QUESTIONS

- September 08, 2014

Q: What is SSRS? Ø SSRS or SQL Server Reporting Service is a server-based report generation software systems from Microsoft and is part of Microsoft BI. Ø It is used for preparing and delivering interactive and variety of reports. Ø It is administered through an web based interface. Ø Reporting services utilizes a web service interface for supporting and developing of customized reporting applications. Ø SSRS lets you create very rich reports (Tabular/Graphical/Interactive) from various datasources with rich data visualization (Charts, Maps, sparklines) Ø SSRS allows are reports to be exported in various formats (Excel, PDF, word etc) Q: Explain SSRS Architecture? Reporting services architecture comprises of integrated components. It is a multi-tiered, included with application, server and data layers. This architecture is scalable and modular. A single installation can be used across multiple computers. It includes the fo...

Exception deserializing the package "The process cannot access the file because it is being used by another process."

- December 13, 2019

TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got...

Failed to execute the package or element. Build errors were encountered

- November 28, 2018

Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element. Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------ Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package

Powered by Blogger

Balu Challa

Blog Archive

2026 20
- April 2
- March 9
- February 4
- January 5

2025 23
- October 1
- September 2
- August 1
- June 1
- April 4
- March 4
- February 7
- January 3
2024 32
- December 2
- November 1
- October 2
- August 2
- June 1
- May 1
- April 6
- March 4
- February 4
- January 9
2023 31
- December 2
- November 1
- September 3
- August 3
- July 3
- May 1
- March 4
- February 1
- January 13
2022 94
- December 6
- November 13
- October 3
- September 4
- August 10
- July 12
- June 2
- May 4
- April 12
- March 9
- February 7
- January 12
2021 183
- December 12
- November 7
- October 11
- September 24
- August 10
- July 17
- June 15
- May 27
- April 25
- March 33
- February 2
2020 15
2019 31
2018 49
- December 3
- November 2
- October 7
- July 14
- June 21
- February 2
2017 18
2016 39
- August 19
- July 7
- June 5
- April 4
- January 4
2015 2
- March 2
2014 57
2013 2
- December 2

Show more Show less

Labels

2016
2017
2019
2021
2022
2023
2024
2025
2026
Access DB

Show more Show less

Popular posts from this blog

SSRS INTERVIEW QUESTIONS

- September 08, 2014

Q: What is SSRS? Ø SSRS or SQL Server Reporting Service is a server-based report generation software systems from Microsoft and is part of Microsoft BI. Ø It is used for preparing and delivering interactive and variety of reports. Ø It is administered through an web based interface. Ø Reporting services utilizes a web service interface for supporting and developing of customized reporting applications. Ø SSRS lets you create very rich reports (Tabular/Graphical/Interactive) from various datasources with rich data visualization (Charts, Maps, sparklines) Ø SSRS allows are reports to be exported in various formats (Excel, PDF, word etc) Q: Explain SSRS Architecture? Reporting services architecture comprises of integrated components. It is a multi-tiered, included with application, server and data layers. This architecture is scalable and modular. A single installation can be used across multiple computers. It includes the fo...

Exception deserializing the package "The process cannot access the file because it is being used by another process."

- December 13, 2019

TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got...

Failed to execute the package or element. Build errors were encountered

- November 28, 2018

Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element. Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------ Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package

Temporary enable and disable SSRS subscriptions

- August 11, 2019

--Code Snippet --To Check Subscription Status. USE ReportServer GO SELECT dbo . Subscriptions . Description , dbo . [Catalog] . Name , dbo . Users . UserName , InactiveFlags FROM dbo . Subscriptions INNER JOIN dbo . [Catalog] ON dbo . Subscriptions . Report_OID = dbo . [Catalog] . ItemID INNER JOIN dbo . Users ON dbo . Subscriptions . OwnerID = dbo . Users . UserID --Temporary disables subscriptions while data warehouse is unavailable UPDATE dbo . Subscriptions SET InactiveFlags = 1 GO --After this you can find, all the subscription where disabled until you again enable it. --Again enable subscriptions. UPDATE dbo . Subscriptions SET InactiveFlags = 0 GO

Updates to org apps (Preview)

- April 03, 2025

Updates to org apps (Preview) – more customization, deployment pipelines, and Git – plus what’s next like new license support and audiences! We’ve heard a lot of positive feedback on org apps and clear suggestions on what we should build next to meet your organization’s data distribution and consumption needs. With your feedback, we’ve made several updates to org apps and have more in the works. Let’s get right to what’s new and then we’ll cover what’s coming next as we work towards general availability of org apps. Now available: New combined navigation setting for customizing your org apps. Git support for org app developers looking for version history. Deployment pipelines for staging and testing your org apps across workspaces. What’s next: Support for org apps in Pro workspaces. Add paginated reports to org apps, with org app-managed access propagation for semantic models. View org apps in Power BI mobile apps. Conditio...

Followers

Translate