Welcome to EMC Consulting Blogs

April 2008 - Posts

• Do you friendfeed?

  Is anyone out there using friendfeed ? I got switched onto it about a month ago and have been "using" it ever since to publish my various blog, photo and random paraphernalia. What I really like about it is that "using it" consists of setting up all your Read More... Posted 22 April 2008 11:56 by jamie.thomson | 0 Comments Filed under: Friendfeed

• SSIS: Deleting a group of files

  A question I quite often see on the SSIS forum is: Is there a way to delete a group of files within a directory? ie: I want to delete all files in directorty c:\logs\*.txt ( http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3196521&SiteID=1 ) Read More... Posted 17 April 2008 22:38 by jamie.thomson | 3 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft, Foreach Loop

• SSIS: Data Profiling Task: Part 10 - Parsing the output

  Back in February and March I wrote a series of blog entries explaining how to use the various profile requests in the new Data Profiling Task that is coming in SSIS 2008. All of those blog entries explained how to profile some data and analyse it offline Read More... Posted 16 April 2008 07:42 by jamie.thomson | 5 Comments Filed under: SQL Server Integration Services, SSIS, Data Profiling

• SSIS: Package parts

  As SQL Server 2008 is practically now a done deal my thoughts have turned to what will come in future versions. One feature I would like is something I'm notionally calling "package parts". Let me explain. Today in SSIS we build, distribute and execute Read More... Posted 15 April 2008 22:39 by jamie.thomson | 28 Comments Filed under: SQL Server Integration Services, SSIS

• SSIS: MVP Summit 2008

  Next Monday (14th April) brings with it the start of the Microsoft MVP Summit 2008. This is an opportunity for all of the (give or take a few) 4000 MVPs from around the world to travel to Seattle and engage with Microsoft product teams with a view to Read More... Posted 10 April 2008 12:13 by jamie.thomson | 21 Comments Filed under: SQL Server Integration Services, SSIS, Microsoft