SSIS on a cluster
I figured this was worth a quick post: while many of SQL Server’s aspects are cluster aware, SSIS is not. Why? My guess is that there is not a pressing business need for this to be a cluster … more
Business Intelligence and SQL Server
Contents tagged with SSIS
TPC Benchmark Status – April 2009
For anyone unfamiliar with the TPC (Transaction Processing Performance Council), they are an independent non-profit with the goal of creating benchmarks for database systems that are verifiable and … more
CodePlex project for Data Profiling
I made a post over a week ago talking about extending the Data Profiling task and in there I just cover the some of the basics on my methods for extending it and what goals I had in mind. It … more
Extending the Data Profiling Task
SQL Server 2008 RTM has been out a while now and yet, I am just now making my way to using the Data Profiling Task, new to SSIS in this release. Time and client demands are always a factor … more
Dynamically remapping source to destination in SSIS
This all started off in trying to help out a fellow SSIS enthusiast, and now I have made a complete project as a sample….. catch the MSDN forum thread here. There are many reasons why you … more
SSIS Caching and Performance
I've been trying to be a good citizen and post more in the SQL Server section of the MSDN forums, and so I came across a question in the SQL Server > SSIS section about start-up performance … more
SSIS Adapter for SharePoint
Kevin Idzi of Microsoft was kind enough to leave a comment on my Extracting SharePoint Data using SSIS post informing me of Integration Services enhancements posted on CodePlex.I had been … more
Business Intelligence Metadata Whitepaper
It is hard enough to manage your data repository, modify it to meet new business needs, and add to that: keeping documentation and metadata up to date and relevant for your consumers. Several … more
ETL, Auditing and Row Counts...
Yes, it has been too long since I last posted – My wife and I are in the middle of selling our house, so it has been a busy month doing little projects here and there. For anyone doing ETL … more
Variable locking in SSIS
Recently a package of mine with a good running history suddenly started throwing errors. This package had been scheduled and running just fine for over a month – no changes to the code had been … more
