MS SQL Server Business Intelligence

Menu Items

Home
SQL
T-SQL
SSIS
SSRS
SSAS
Questions

SQL

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

No comments:

Popular Posts

New features are available in SSIS Denali(2012) over 2008 R2

GUI IMPROVEMENTS • Getting started window • Package visualization • Zoom • Undo • SSIS toolb...
SSIS various tasks description

A task can best be described as an individual unit of work. We can also develop our own tasks, but here are the current ETL Tasks avail...
New features are available in SSAS Denali(2012) over 2008 R2

· The new release is based on the vision to reach a broader user base · SSAS brings together the existing multi-di...
Hardware and Software Requirements to Install SQL Server 2012 (Denali)

· Microsoft recommends using NTFS file format instead of FAT32. FAT32 will work but you should probably not use it. · ...
SSIS New Features in SQL Server 2008

Scripting Task SQL Server 2008 scripting is built on the improved VSTA (Visual Studio Tools for Applications) rather than the VSA (Visual...
If your database user login is assigned to the db_ssisoperator role, which has only read access and does not have write access to a package stored in msdb, what are you able to do with the package?

Ans. Because you are assigned the db_ssisoperator role, you can execute the package inside msdb, but you cannot delete the package from...
New features are available in SSRS Denali(2012) over 2008 R2

There's not much new in Denali for SSRS. I vaguely recall reading that the SSRS team got most of their big enhancements into 2008 R2 ...
Interactive Sorting -- SSRS Tutorial
What is the difference between a control flow task and a control flow container?

Control flow tasks perform operations, whereas containers coordinate and group tasks. Example : a foreach Loop Container can look throug...
SSRS 2008 Tutorial - Grouping

SSRS 2008 Tutorial - Grouping