Author Archives: Zahid

About Zahid

Team Lead at IQVIA (www.iqvia.com). Fields of expertise are C#,BI Reporting (MSBI, Microstrategy, Excel, ASP.NET Dashboards etc.) , ETL, Data Warehouse, OLAP Cube, MDX etc.

Understanding crossjoin, set, tuples with help of SetToStr function

MDX cross join function returns the cross product of two sets. For example, we have two sets A = {1,2} and B = {x,y}. After crossjoin, we get, A X B = {(1,x),(1,y),(2,x),(2,y)}. (1,x), (1,y) are individual tuples. The resultant … Continue reading

Posted in MDX, SSAS (Analysis Service), Cube | Tagged , , , | Leave a comment

Composite Domain Rules (CD Rules) in Data Correction

Hello all I am just learning DQS and would like to share a few things that I learned so far. One of them is the use of composite domains (CD). I will go straight into an example rather than wasting … Continue reading

Posted in Data Quality Service (DQS) | Tagged , , , , , | Leave a comment

Set Synonyms in DQS

This is my first post on the newly added Data Quality Service of MS SQL Server. It’s about setting up synonyms in Domain Values. The steps are : 1. select “domain management” activity for your knowledge base (KB) 2. select a domain … Continue reading

Posted in Data Quality Service (DQS) | Tagged , , , | Leave a comment

Load Excel File Dynamically Into Database Using SQLBulkCopy and GetOleDbSchemaTable in C#

Previously, I have posted some SSIS solutions which would handle dynamic column mapping in data loading. This time, I was wondering how to handle dynamic column mapping when the source is an excel file. I was quick to realize that … Continue reading

Posted in MS Visual Studio, C#.NET, SQL, Database, SSIS (SQL Server Integration Service) | Tagged , , , , , | 13 Comments

Access SSIS variables in script task and script component

You have to write codes to access the variables in these two components in a slight different way. For Script Task: DTS.Variables[“VariableName”].Value For Script Component: Variables.VariableName Don’t forget to add these variables in task editor first. 🙂

Posted in SSIS (SQL Server Integration Service) | Tagged , , | Leave a comment

Find out anagram using SQL

Any word or phrase that exactly reproduces the letters in another order is an anagram. For example: “Hamlet” is an anagram of the word “Amleth”. We will show u a query today which can determine if two given words are … Continue reading

Posted in SQL, Database | Tagged , | Leave a comment

Avoid Concurrency problem while running SQL Server Jobs

Hello everyone, This time my problem was to delay the start of a SQL server job if another job is already running. Obviously, the reason for this is that the jobs use the same database resources. The sysjobhistory table in … Continue reading

Posted in SQL, Database, SSIS (SQL Server Integration Service) | Tagged , , , , , | Leave a comment