MSBI Tutor

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

TITLE: Microsoft Visual Studio ------------------------------ Error at Load_Invoice [Merge Join [103]]: The column with the SortKeyPosition value of 1 is not valid. It should be 0. ------------------------------ ADDITIONAL INFORMATION: Exception from HRESULT: 0xC02020B5 (Microsoft.SqlServer.DTSPipelineWrap) ------------------------------ BUTTONS: OK ------------------------------ Solution: It seems to you need to refresh the metadata 1. Delete existing Merge Join transformation 2. Drag and drop new Merge Join transformation. 3. Provide proper connections.