By Erin Welker, 04/09/2008
By Erin Welker, 03/28/2008
Easily debug packages, Control Flow tasks, and Data Flow tasks and log package-execution information using the debugging and logging capabilities in SSIS.
By Erin Welker, 03/28/2008
Find out how to assign a compatible data type to the data destination(s) early in the pipeline to avoid data-type conflicts.
By Erin Welker, 03/22/2007
Deciding to upgrade from Analysis Services 2000 to 2005 might be a no-brainer, but figuring out how to move your cubes can be a more complicated process. Here are some key ...
By Erin Welker, 03/22/2007
The new terminology in SQL Server 2005 Analysis Services (SSAS) can seem intimidating, but you can simplify it by using this vocabulary equivalency chart.
By Erin Welker, 03/22/2007
Virtually any object in Analysis Services 2005 can be scripted in XMLA. Here's a checklist for scripting objects and a sample script.