Mark V SQL

When you first create a configuration file in your Integration Services project, the XML contents of the file are just laid out in one long line. This makes reading and/or modifying this file more challenging than it needs to be.
There is an easy way to format your file to alleviate this issue. In BIDS, [...]

I have been working on a project modifying the ETL for a data warehouse. The source is a Pervasive database which, through SSIS 2005 packages, populates a SQL Server 2005 data warehouse and associated SSAS 2005 cubes. I encountered an issue which reminded me of a scene in the first Indiana Jones film, Raiders of [...]

I was trying to dynamically send multiple attachments via the Send Mail Task in a package.
In the Send Mail Task Editor, when clicking on the Attachments property field, the tool tip tells you that the file names must be separated by semicolons:
“Specifies the files to include as attachments to the message. Separate the file [...]