Archive for category: SSIS

SQL Server Integration Services related musings

An SSIS Training Video by Webucator

15 April, 2016 (12:38) | SSIS | By: Mark V

Greetings, noble readers! A while back, Webucator, an organization that produces training videos on a number of topics, contacted me about doing a video walkthrough of one of my blog posts. The original post is Making Your SSIS Configuration Files More Readable. Their video walkthrough is here. Feel free to check out this video and […]

TARDIS – Time And Relative Distribution In SSIS

16 June, 2015 (10:00) | SSIS | By: Mark V

Fans of Dr. Who will immediately recognize the title of this post. In that classic science fiction series, the Doctor has a very special vessel that lets him travel anywhere in Time and Space, even across dimensions. That vessel is called the T.A.R.D.I.S. (Time And Relative Dimension In Space). As I was crafting the idea […]

PASS Summit 2013 Interview with Matt Masson

28 October, 2013 (10:00) | Interviews, PASS, SSIS | By: Mark V

At PASS Summit 2013 in Charlotte, I had the opportunity to sit down with Matt Masson (Blog|Twitter), Senior Program Manager on the Integration Services Team at Microsoft. I was really honored when Matt explained how busy his week was and then offered me a half hour anyway. I want to give a tremendous THANK YOU […]

Jim Croce and the Foreach (File) Loop Container

28 January, 2011 (06:00) | Songs, SQL, SSIS | By: Mark V

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.

Making Your SSIS Configuration Files More Readable

15 April, 2010 (10:45) | SSIS, XML | By: Mark V

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, […]

Saving Indiana Jones (and your SSIS packages) From “Bad Dates”

8 February, 2010 (13:55) | SQL, SSIS | By: Mark V

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

Incorrect Information in SSIS 2005 Send Mail Task Tooltip For Attachments Property

18 June, 2009 (11:09) | SSIS | By: Mark V

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