Connection string
Naomi Nosonovsky
8,881
Reputation points
Hello,
I have a connection string which works on the old production server but doesn't work on the new production server.
<?xml version="1.0"?>
<DTSConfiguration>
<DTSConfigurationHeading>
<DTSConfigurationFileInfo GeneratedFromPackageID="{10E2A9ED-0958-4AA1-95D7-730C4CD1D8A1}" GeneratedDate="8/4/2017 10:46:38 AM"/>
</DTSConfigurationHeading>
<Configuration ConfiguredType="Property" Path="\Package.Connections[ETL_DATABASE].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>Integrated Security=SSPI;Provider=SQLNCLI11;Persist Security Info=False;Initial Catalog=VA_REPOSITORY;Data Source=CCNPDTRAGL0200I;Use Encryption for Data=True;Trust Server Certificate=True;</ConfiguredValue>
</Configuration>
</DTSConfiguration>
Can someone please help to figure out what may wrong with it?
Thanks in advance
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Sign in to answer