ADO.NET Connection Manager Troubleshooting
You can log the calls that the ADO.NET connection manager makes to external data providers. You can use this logging capability to troubleshoot the connections that the ADO.NET connection manager makes to external data sources. To log the calls that the ADO.NET connection manager makes to external data providers, enable package logging and select the Diagnostic event at the package level. For more information, see Troubleshooting Tools for Package Execution.
When being read by an ADO.NET connection manager, data of certain SQL Server date data types will generate the results shown in the following table.