Friday, June 14, 2013

What is SQL Client Connectivity SDK in SQL 2008 R2 Installer

During an install I was wondering what this option did?


SQL Client Connectivity SDK and Client Tools SDK provided the Wrapper objects for COM components.

Client Tools SDK Provide wrappers classes for DTSRuntime and similar components that you can use to Execute a .dtsx (SSIS) package on demand. Most of the People install Integration Service to perform similar task.

Also SQL Client Connectivity SDK plays a key role in providing Microsoft.SQLServer.Diganostics.STrace library used by Client Tools.

Now, you can use this Wrapper classes to run a SSIS package from within your WCF/WebService/Windows Service or any other .Net App without calling a SQL Agent Job.

there are probably more uses to this library and would be great if someone added to my comment.

Thanks Pawan Gonnakuti
http://connect.microsoft.com/SQLServer/feedback/details/381445/sql-client-connectivity-sdk-and-client-tools-sdk-documentation

No comments:

Post a Comment