Pivoting Diagnoses, Procedures and POA using a Stored Procedure called from SSIS8/3/2011 - In this article, I describe the way in which I used a stored procedure to pivot data into columns as well as the use of SSIS in automating the process of extracting data from SQL Server, transmitting to my customer and notifying us in an automated fashion.
Handling Complex Text Files in SSIS12/7/2011 - One of the challenges when working with flat files in SSIS comes when record types are mixed in a single file. This is a common scenario in health care where often times header and detail records and mixed and are only tied together by the fact that they occur sequentially in the flat file. Unfortunately SSIS has no built in process to help a developer overcome this hurdle. Luckily with a little bit of code and the script transformation we can parse and process these types of file with ease.
Use SQL To Write Your SQL Code!12/30/2011 - The idea of using SQL scripts to automatically generate SQL code is one that can be applied to many situations, especially when you need to process many different database objects.
Discover the power of Microsoft SQL Server with sql server business intelligence25 days ago - SQL 2005 or 2008, how do you configure security to allow a user to SELECT data from a table but not view the table definition?
Creating 5 Star Rating using Indicators in SSRS 2008 R21/3/2012 - Creating 5 Star Rating using Indicators in SSRS 2008 R2
ETL Best Practice - Pre-Treat your Data!11/24/2011 - Do you have headaches caused by messy source data? This article provides an easy way to test and pre-treat your source data at the beginning of your package's Data Flow Task.
how to do impact analysis in ssis packages to find database tables and stored procedures5/3/2011 - In this article you will learn how to perform impact analysis for sql server, ssis and other BI Objects.
More Featured Articles