Conditional Split in SSIS

This transformation lets you route your data flow to different outputs, based on criteria defined within the transformation’s editor.

What is use of Show Server Trace option in SQL Query Analyzer

Use Show Server Trace option in SQL Query Analyzer to analyze and tune stored procedures.

DelayValidation Property DelayValidation property indicates whether validation of the task is delayed until run time.

SQL SERVER – Get Current TimeZone Name in SQL Server Use below sql script to get timezone of sql server : DECLARE @TimeZone VARCHAR(50) EXEC […]