An ADO.NET connection manager enables a package to access data sources by using a .NET provider. This connection manager is typically used to access data sources such as Microsoft SQL Server, and also data sources exposed through OLE DB and XML in custom tasks that are written in managed code by using a language such C#.