troubleshooting Question

SSIS - importing a csv file into SQL table

Avatar of qprjohn121
qprjohn121 asked on
Microsoft SQL ServerMicrosoft SQL Server 2008Databases
8 Comments1 Solution2179 ViewsLast Modified:
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'
2. 'STUDIOXPSLAPTOP.Warehouse'

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?

Thanks
ASKER CERTIFIED SOLUTION
nmcdermaid

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros