Breaking down SSIS keystring values for connection manager between Server2000 and Server20008
the provider is the driver name. A connection can be opened against variuos sources and destination (SQL server, Oracle etc..). You have to specify the proper driver.
SQLNCLI10.1 is the sql server native client version 10.1
OLE DB Services=-13; is the default option for additional features like pooling and recursion etc...
Application Name is only a string that can be usefull to distinguish the running workload from other applications. Most of times you can find &quot;.NET application&quot; or the ssis dtsx name or id like in this case.