SSIS configuration file ConnectionString Application-Name

• SJanki

  SSCrazy

  Points: 2847

  More actions

  June 11, 2012 at 12:44 pm

  #262265

  What is the Application Name attribute in the connection-string of an ssis configuration file?

  I want to deploy the package into test server , shall I remove this attribute?

  Thanks

  ~SJ

  <Configuration ConfiguredType="Property" Path="\Package.Connections[Source AAA Staging db].Properties[ConnectionString]" ValueType="String"><ConfiguredValue>Data Source=XXX\YYY;User ID=;Initial Catalog=CCC-Staging;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;Application Name=SSIS-Package-{8C173805-D768-4DA1-A2B5-0D3BC300F7EB}XXX\YYY.ACT-Staging-Sample;</ConfiguredValue></Configuration>

• SJanki

  SSCrazy

  Points: 2847

  More actions

  June 11, 2012 at 3:48 pm

  #1499552

  SJanki (6/11/2012)

  ---

  What is the Application Name attribute in the connection-string of an ssis configuration file?

  I want to deploy the package into test server , shall I remove this attribute?

  Thanks

  ~SJ

  Please ignore this question!!!!

  Thanks.