Skip to content

Instantly share code, notes, and snippets.

@RichieBzzzt

RichieBzzzt/updated_connection_manager.xml

Created October 3, 2017 11:09
Show Gist options
  • Save RichieBzzzt/0f2e953c30700ec020ee2fbb7f683318 to your computer and use it in GitHub Desktop.
Save RichieBzzzt/0f2e953c30700ec020ee2fbb7f683318 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
updated_connection_manager.xml
<?xml version="1.0"?>
<DTS:ConnectionManager xmlns:DTS="www.microsoft.com/SqlServer/Dts"
DTS:ObjectName="WWI_DW_Destination_DB"
DTS:DTSID="{7C3E3ECC-C5AD-4675-9618-FC08465F8BC9}"
DTS:CreationName="OLEDB">
<DTS:PropertyExpression
DTS:Name="ServerName">@[$Project::ServerInstance]</DTS:PropertyExpression>
<DTS:ObjectData>
<DTS:ConnectionManager
DTS:ConnectionString="Data Source=.;Initial Catalog=WideWorldImportersDW;Provider=SQLNCLI11.1;Integrated Security=SSPI;Auto Translate=False;" />
</DTS:ObjectData>
</DTS:ConnectionManager>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment