Category Archives: Integration Services

How to use SSIS Log Analyzer tool ? (Video)

While Optimizing SSIS packages, analyzing package log is really a pain as these log files are flat files and long so I lost focuses while reviewing. I was looking for a smart tool to analyze the my SSIS logs and figured out this utility (SSIS Log Analyzer) , which is freely available at Microsoft. This [...]

SQL Server Integration Services: Merge Join Transformation

This is a guest post by Girish Khullar, If you want to guest post on this blog, contact me . What is Merge Join Transformation? You may have gone through this question a lot of time while working that what is the thumb rule to use Look Up transformation or Merge Transformation. Lets have a [...]

Denali : Integration Services now Supports undo and redo (CTL+Z and CTL+Y)operations

In BIDS (SQL Server Business Intelligence Development Studio) SQL Server 2005 and SQL Server 2008 when you delete something from the design surface it is gone, kind of permanent. The only real way of getting the deleted item(s) back is to revert to a previous version of the package or to redo the deleted items [...]

SQL Server Denali : Integration Services (SSIS) Enhancement – Video Tutorials

Microsoft made a number of improvements on this new release "Denali" specially for Integration Services. These are some of the key improvements in SSIS Migration and Deployment Working with Integration Services projects in Business Intelligence Development Studio (BIDS) Using the Deployment Wizard to deploy an Integration Services project Import an Integration Services Project from the [...]

Video : How to Export SQL Server Data to Excel

Copying data from SQL Server to Excel is business requirement. Today I got this question by one of the blog reader, who wanted to learn "How to Export SQL Server Data to Excel" Exporting data from SQL Server to Excel can be achieved in a variety of ways like Data Transformation Services (DTS) SQL Server [...]

Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010

Microsoft PowerPivot for Microsoft Excel 2010 is a data analysis tool that offers unmatched efficacy directly into the software that users already know and love: Microsoft ® Excel. You can transform massive amounts of data with incredible speed into meaningful information to get the answers you need in seconds. You can share your findings with [...]

New Features of SQL Server 2008

Here is the list of top 51 features of SQL Server 2008 which are present in SQL Server 2008 sales Boucher. My objective to cover all new features of SQL Server 2008 with detailed concept delivery with videos. Policy-Based Management Policy-Based Management is a policy-based system for managing one or more instances of SQL Server [...]