SSAS Processing Failure; OLE DB or ODBC error – 08001

Today I faced a new error type that I’d never seen before in my many years of experience with SSAS. It was one of the most weird errors that I’ve seen so far. let me explain that in a scenario; I had a SSAS multi-dimensional cube working and fully processing on the DEV server. then Read more about SSAS Processing Failure; OLE DB or ODBC error – 08001[…]

Format String Issue of SSAS Measures in Excel Front-End

Most of you faced such situation that you’ve set the FormatString property of your measures in the cube from BIDS or SSDT, But when you browser the cube in Excel you will not see that format. Let’s say you applied format string to add thousands separator, two decimal points, and dollar sign to your Amount Read more about Format String Issue of SSAS Measures in Excel Front-End[…]

Fixing the error: The multi-part identifier … could not be bound in Join statements

One of the most common errors that you might face in join statements is this error: Msg 4104, Level 16, State 1, Line … The multi-part identifier …… could not be bound. The main reason for this error is that the source table cannot be found, for example if you have statement such as Table1.OrderDate, Read more about Fixing the error: The multi-part identifier … could not be bound in Join statements[…]

Error Handling in SSIS; Download presentation materials and recording

Thanks for all attendees of today’s webinar about Error Handling in SSIS. turnout was good, and good questions asked and responded. Here are topics that covered in this session: Error handling in SSIS Data Taps Logging SSIS Catalog stored procedures for Logging and execution Debugging and Troubleshooting SSIS packages some live demos about error handling, Read more about Error Handling in SSIS; Download presentation materials and recording[…]

SSAS Deployment Error: No Mapping between Account Names and Security IDs was Done.

This is a common error in SQL Server Analysis Services (SSAS). when you deploy the project to SSAS Server, you might face this error. Reason: There are some user/group membership added to roles in SSAS project, that is not matching with Active Directory user/groups. for example you might find some membership entries with GUID listed Read more about SSAS Deployment Error: No Mapping between Account Names and Security IDs was Done.[…]

DQS Error : Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo

If you faced this error when you want to connect Data Quality Services (from Data Quality Client or from SSIS DQS Cleansing component); Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo You can fix it in following way; Why this happens: When .NET Framework Read more about DQS Error : Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo[…]

How to get rid of TESTING CONNECTIVITY at the time of Opening SSIS packages in SSDT

SSDT has an option to test connectivity of connection managers at the time of opening the SSIS package. You can change this behaviour with WORK OFFLINE option. When you have many connection managers in SSIS package, you may face a halt at the time of opening each package with a “testing connectivity” message. This will Read more about How to get rid of TESTING CONNECTIVITY at the time of Opening SSIS packages in SSDT[…]

How to handle Failed Rows in a Data Flow

suppose this scenario: you have a source table and a destination table, you want to transfer rows from source table to destination table, so you can use simple data flow with OLE DB source and OLE DB Destination. but problem hits when destination table has few rows inside, and there is Unique Constraint in ID Read more about How to handle Failed Rows in a Data Flow[…]

Problem with comma values in Comma Delimited File

Assume .csv file which columns delimited by comma ( , ) . and Texts delimited by Double Quote ( " ) like below: "Invoice Number","Invoice Status","Invoice Date of Service","Invoice Date Opened","Invoice Hold from printing/submission","Invoice Branch","Invoice Balances Adjustments","Invoice Balances Payments","Invoice Balances Balance","Patient Last Name","Patient First Name","Patient ID","Policy Payor Name","Invoice Detail Item ID","Invoice Detail Item Name","Invoice Detail Read more about Problem with comma values in Comma Delimited File[…]