I want to work with a table from SQL Server in an SSIS data flow. One of the columns of the table is date
type. When I import it to SSIS using OLE DB source component, SSIS changes the metadata of this column to WSTR
.
Do you have any idea how to fix it? I think that it never happened before. I know I can force SSIS to change the data type in advanced editor, but shouldn't SSIS "know" that this is date
type column and convert it into DT_DATE
?
I use SQLOLEDB.1
as the provider. It's SQL Server 2012 and the data type of the column is just date
.