Problem Statement: How to check the execution status of a SSIS package, deployed in SSISDB, using system tables? Solution: DECLARE @status INT=2/*Running The possible values are created (1), running […]Read more
Month: November 2015
SQL Server-Check Data difference between two tables
Problem: How to compare tables and/or data to identify data changes between them? Solution: In data migration, we often have to compare two[…]Read more
PowerShell – Do Not use Write-Host!!!!!
Problem Statement: People often use Write-Host in their script, but it is considered harmful. Use other options instead. Solution: Write-Host is always[…]Read more