Log in | Register

Business Intelligence Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education Business Intelligence Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

Business Intelligence

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

SQL Server Integration Services – An Alternate to Slowly Changing Dimensions

Hi Friends,

The blog post will teach you to achieve the same effect as slowly changing Dimension (SCD) transformation without using the SCD transformation of SSIS.

The steps will guide you as to how we can create the SCD effect using the transformations in SSIS without using SCD.

The SCD is used to populate the Dimension tables […]

SQL Server 2005 SSIS Error Loading Type Library/DLL

As part of consolidation for a client, I came across a minor issue with SQL Server 2005 SSIS. While opening SQL Server 2005 SSIS there was an error ‘Loading Type Library/DLL’. The first thing I crossed checked was if I was using the correct SSMS version and no issues there. Looked at the error one […]

SQL Server Integration Services – Performing Audit in SSIS

Hi Friends,

In this blog post, let’s have an insight on how Auditing can be done in SQL Server Integration Services packages?

The basic auditing in package includes measures like

How many rows were inserted, updated or deleted, package name, status, etc. The information to be captured depends on personal choice or project needs.

So, Let’s create a simple […]

SQL Server Integration Services – Sequentially Inserting rows into Excel Spreadsheets from sql server table

Hi Friends,

Here’s an interesting scenario on SQL Server Integration Services.

How to Sequentialy Insert specific number of rows into excel spreadsheet and dynamically generate a new spreadsheet for next set of sequential insert?

Suppose, I have 10000 records in my table and i want to export  a specific number of rows, let’s say 900 records in […]

SQL Server Integration Services – How to configure single Source and destination in Data flow to be used by multiple databases and flat files?

Hi Friends,

A few days back I came across a scenario where there were multiple flat files and the data were to be loaded into different databases. The good thing about the whole process was that the files were named in format

[db_name]_data.txt

And the table structures were same in all the databases, also data structure in […]

Newsletter_Footer