I've used ADO.NET this way, and it even says it's possible in the provided documentation:

The source converts any data type that does not map to a specific Integration Services data type to the DT_NTEXT Integration Services data type. This conversion occurs even if the data type is System.Object.