Breakpoints in SQL Server 2005 Integration Services SSIS

In SQL Server 2000's Data Transformation Services (DTS) the tool had the ability to issue each portion of a package one step at a time. With some custom coding, it was possible to determine variables and the package status by creating T-SQL tasks to writ

www.mssqltips.com