I am still stuck after some research on the internet and hope someone can help me. My goal is to bring in Microsoft SQL Server Integration Services (SSIS), date or numeric values with different formats (22.01.2023, 01/22/2023, ...) from different cultures (German, USA, etc.) into a consistent format. What I have found out so far:
When within a dataflow task a source component (e.g. OLE DB Source) extracts data from a database, the matching data types are mapped and convertet from the database by the dataflow engine to the corresponding SSIS data types. (Source)
I also know that e.g. SQL Server stores the date values only in bytes, which displays the date in the format of the set OS language on the graphical user interface = all date values are stored in the same format and are only converted to the corresponding set language format at the output for the user. (Source)
Microsoft itself says: "However, the date is in the ISO format of YYYY-MM-DD, regardless of whether the locale preference uses the ISO format." (Source)
Does this mean that all date formats extracted into an SSIS package from source components are automatically converted to the ISO format and saved? So, do I no longer have to do the conversion of data formats from different cultures myself but can "leave it" to SSIS?
I tried to extract data in different formats from excel or SQL Server tables but ended up in having automatically the ISO date format.