Mark V SQL

I am the guest blogger on Jason Strate’s 31 Days of SSIS series today. Jason ( blog | Twitter ) has the post up on his site at 31 Days of SSIS – Jim Croce and the Foreach (File) Loop Containiner (28/31). Thanks again to Jason for the great opportunity.

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 [...]