Hello,
We recently made the following observation working with VS2022 combined with the SSIS extension 'SQL Server Integration Services Projects 2022 (version 1.5)
When creating a connection manager the driver of choice is set to SQLOLEDB.1
With these type of connection string the SQL datatype 'date' is not recognized and set to WSTR(10) , be it source/target / lookup 'widgets'.
When I manually change connection string to provider SQLNCLI11.1, then the issue is resolved.
The datatype 'date' voor SQL was added with SQL2008, so I am at a loss why this is still an issue with 2022 versions.
I installed latest OLE DB drivers for 64bit to no avail, but does anyone have the same experience with SSIS in this respect?
- This topic was modified 4 hours, 19 minutes ago by blom0344. Reason: reservation changed to observation