Thanks to Michael Entin's helpful article this was one of those head slapping moments. He explains that if you load a .dtsx file standalone into Visual Studio the debug buttons are disabled because it is the project configuration that facilitates these. So the solution is to create a new SSIS ... [More]

This is the first thing I've ever had to do in SQL Server Integration Services. I needed to create a package that output records from a database to an xml file in the file system. The data was retrieved using an OLE DB source and stored procedures (the easy part) but because SSIS doesn'... [More]