In SQL, Stored procedures provide the option to use Output parameters as a way to return back data to the query which has called the procedure, and this can in turn, be beneficial for improved code organization and better performance. With our latest version of SSIS Productivity Pack, we have introduced Output parameter handling support to a few of our component tasks. In this blog post, we will be looking specifically at our Premium SQL Server components and how they can manage this.

In this blog post, we will show a simple solution that can be used to generate the JSON structure from database tables which can be sent to CDS/CRM destination components for writing, we demonstrate the use of SQL FOR JSON clause to achieve the purpose.

In this blog post, we demonstrate how to connect to CDS/CRM Online SQL database through an ADO.NET Connection Manager and query data using the Premium ADO NET Source component, a part of our SSIS Productivity Pack.

In this blog post, we demonstrate how to use the Pre & Post Commands feature in the Premium ADO.NET components to run SQL statements or set session variables before or after executing our components.

We have received a few reporting from our customers saying "The connection manager '' is not properly installed on this computer" when using SSDT-BI for Visual Studio 2013, this blog post tries to direct you to the download link which includes a fix for this issue.

We have received a couple of reporting of the error mentioned in the title for SSIS Integration Toolkit for Dynamics CRM. We have done some preliminary investigation and we believe this is a SQL Server bug. Read for more information about the error and workaround solution.

Today, we are happy to announce that we have just launched a new website called SQL2FetchXML.com, which is a free online converter that helps convert SQL script into CRM FetchXML query.