Ssis-977 -

– In the OLE DB Source, explicitly set the Data Access Mode to “SQL Command” and cast the datetimeoffset column to datetime2(7) using the CAST function. Example:

The symptom most users encounter is a similar to the following: ssis-977

– Write a small C# script component that reads the raw binary representation of the column ( byte[] ) and reconstructs the DateTimeOffset using .NET’s DateTimeOffset.ParseExact , thereby controlling precision manually. – In the OLE DB Source, explicitly set

To avoid confusion, it is important to distinguish between the two primary uses of this acronym: – In the OLE DB Source