Welcome to EMC Consulting Blogs

This is a Public Service Announcement.  Attunity makers of all things connect-y for SSIS are putting on a webinar for their latest product Oracle CDC for SSIS. It’s an enabling solution that accelerates the development of real time data integration with Oracle systems. The event is to be held online on Monday, June 22, 2009 10:00 AM - ...

AAAaaaaah...Yesterday was just one of those days.  I was trying to do something very simple in a script task - assign the current datetime value to one of my variables - and was pulling my stubbly hair out trying to do it. I am happy to confess to not being the strongest .netter in the world but we do also in SSIS get a pretty pony script ...

Here's a useful page to keep an eye on: http://msdn2.microsoft.com/en-us/library/ms403408.aspx. It lists the current features within SSIS that will be disappearing in future versions and the strongest message I take from it is that you should upgrade your existing DTS packages from SSIS sooner rather than later. Currently it also makes ...

Well it isn't likely to cause quite the same stir as Y2K but I thought it was a significant date for everyone's diaries... On the 8th April 2008 Microsoft withdraws mainstream support for SQL Server 2000. Look here if you don't believe me.  That's not very far away at all.  This gives everyone who is currently ...

For those of you interested in what's new in SSIS in service pack 2, here are a couple of resources: New Features: http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/WhatsNewSQL2005SP2.htm#BKMK_IntegrationServices Bug fixes: http://support.microsoft.com/default.aspx/kb/921896 Note that in SP1 there were alot ...

In case you hadn't picked this up on the grapevine already, Microsoft and Bob Beauchemin SQL Skills have jointly released a whitepaper that talks about connectivity issues that you may come across in SSIS. Check it out here: http://ssis.wik.is/Connectivity_White_Paper   -Jamie  

I have just received an email from Donald Farmer, Group Program Manager for SSIS, who took great delight in telling me that his product has claimed the title of "Best ETL Software" in the Techweb Readers' Choice Awards. I don't usually take much notive of award ceremonies (those god-awful celeb-kiss-@rse award ...

Here is the next in my series of posts explaining how common tasks in DTS can now be implemented in SSIS.Use multiple connection objects in order to maintain seperate connections to a database It was commonly recommended in DTS that a package should contain multiple connection objects pointing to the same database if you had multiple ...

Many people like to use stored procedures as the source of data for the SSIS pipeline. In theory there is nothing wrong with that however it does have its complications. Depending on the way the stored procedure is written, it may or may not be suitable to be used in this way. Namely, it is possible to preview the data being returned from a stored ...

About a month ago I wrote this very simple blog post explaining how one might go about stripping off the last word from a sentance in the pipeline. My Conchango colleague James Saull thought that this would be ripe for a regular expression (and he's right) and asked if we could we apply regular expressions in SSIS. The answer is ...