April, 2008
Debugging and Logging in SSIS
Windows IT Pro
|
March, 2008
Data-Type Conflicts
Find out how to assign a compatible data type to the data destination(s) early in the pipeline to avoid data-type conflicts.
SQL Server Magazine
|
March, 2008
Debugging and Logging in SSIS
Easily debug packages, Control Flow tasks, and Data Flow tasks and log package-execution information using the debugging and logging capabilities in SSIS.
SQL Server Magazine
|
March, 2007
Scripting a Cube in XMLA
Virtually any object in Analysis Services 2005 can be scripted in XMLA. Here's a checklist for scripting objects and a sample script.
SQL Server Magazine
|
March, 2007
Upgrade Your Analysis Services Terminology
The new terminology in SQL Server 2005 Analysis Services (SSAS) can seem intimidating, but you can simplify it by using this vocabulary equivalency chart.
SQL Server Magazine
|
March, 2007
Moving Cubes from Analysis Services 2000 to 2005
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 concepts to help you decide whether to migrate or rebuild your cubes.
SQL Server Magazine
|