OLEDB Connection

Creates an OLE DB connection to a SQL Server database using the SQL Server Native Client 10 (SQLNCLI10) provider with Windows Integrated Security. Adjust the 'Data Source' and 'Initial Catalog' values in the connection string to point at your own server and database.

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
  <Connections>
    <Connection
      Name="Target"
      ConnectionString="Provider=SQLNCLI10.1;Data Source=Localhost;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=AdventureWorksDW"
      />
  </Connections>
</Biml>