This should be really simple but I am pulling my hair out as a result of data conversion issues.
I want to import a csv file (dimDate.csv) into a SQL table (dbo.DimDate) using SSIS. In my data flow task I have 3 components:
1. A Flat File source component called 'DimDate csv file'
2. A Data Conversion component called 'Unicode to ANSI'
3. An OLEDB Destination component called 'SQL Table DimDate'
I also have 2 Connection Managers for the csv file and the SQL database:
1. 'Connection to DimDate Flat File'
In the SSIS Data Flow design view, I have a 'x' in a red circle within the OLEDB Destination component which is alerting me that one of the fields cannot convert between unicode and non-unicode.
The problem field shows in the Flat File Source Component editor as being of data type 'Unicode string [DT_WSTR]'. I have tried many things within the data conversion component but am unable to configure it to remove the alert message.
Please can someone explain what I need to change or configure to make this work?
Microsoft SQL ServerMicrosoft SQL Server 2008Databases
Then double click the destination and close it again to force it to refresh the meta data.
This assumes you want your calendar table to contain unicode data.