Category SSIS

Speaking at SQL Saturday Lisbon #583

In a few days, I will be heading towards Lisbon to speak at the annual SQL Saturday which takes place on Saturday March 11th. On March 9th and 10th, there are 3 preconference workshops held by some of the very knowledgeable people in the industry, so if you are near you don’t want to miss Friday […]

Speaking at MS Cloud Summit 2017

No one is prophet in its own land says the adage. But when it comes to Microsoft Cloud technologies that doesn’t seem to apply. Next week, Monday 23rd, marks the start of the first edition of the MSCloudSummit in Paris, France. This will be my very first public speaking in my country of birth and although […]

Method not found Microsoft.SqlServer.Management.IntegrationServices.EnableSsisSupportAlwaysOnSqmHelper.Initialize()

Today, working with SSIS on a SQL Server 2016 RTM I wasn’t able to create the SSIS Catalog. The error I got was : Method not found: ‘Void Microsoft.SqlServer.Management.IntegrationServices.EnableSsisSupportAlwaysOnSqmHelper.Initialize()’. (Microsoft.SqlServer.IntegrationServices.UITasks) Looking at the documentation for the namespace Microsoft.SqlServer.Management.IntegrationServices I quickly figured out that I would be able to create the SSIS Catalog manually using PowerShell. […]

Speaking at SQL Saturday #526 Rochester

This year, I decided to cut down on the number of SQL Saturdays I would attend, SQL Saturday #526 Rochester is one of the few I submitted to and I was so delighted to get selected. I will present 2 sessions at the event on May 14th. I haven’t been upstate New York since 1986 […]

Dynamic Data Flow using COZYROC component Part II

In the previous post, I explained the problem and the envisaged solution using COZYROC Data flow plus component. This post is the continuation of the required setup for using dynamic data source without the need of knowing its metadata ahead of time. In the foreach loop container that which loop over the data definitions there […]

Dynamic Data Flow using Cozyroc component part I

This is in fact a double double post. Double because it is composed of 2 parts and double because I am writing about two things today: 1 – Open Live Writer (OLW) – The open source version of Windows Live Writer – can be downloaded from there 2 – Cozyroc great SSIS components who had […]