A blog about SQL Server, SSIS, C# and whatever else I happen to be dealing with in my professional life.

Find ramblings

Sunday, September 21, 2014

Biml The connection string format for Connection is not valid

A brief post on resolving errors with Connections in Biml. A friend had sent me some sample Biml and the latest batch wasn't validating. It looked valid, ish, but I was getting
Description: The connection string format for Connection X is not valid Recommendation: Please supply one or more components of the form X=Y, separated by semicolons The supplied code was
<Connection 
    Name="CM_OLE" 
    ConnectionString="Data Source=.\dev2014;Initial Catalog=tempdb;Provider=SQLNCLI11.1;Integrated Security=SSPI;" 
/>
So, what's the issue? It's the trailing space on the ConnectionString. It seems my friends text editor/email program decided to "help" his code by adding that space.

Resolution

Fix the connection string by removing the trailing space inside the ConnectionString property.

No comments: