SSIS package having problem with datename(dw,datum) converting to varchar

Question

I am moving data into a DW using SQL Server SSIS and have the following SQL to populate one dimension

SELECT DISTINCT
cast (datename(dw,datum) as varchar(10)) as veckodag 
FROM XXXXX.dbo.Bought

as I have VARCHAR in the target column I need to CAST/CONVERT

Question how to convert Unicode to Varchar?

I get

*> Validation error. Datum OLE DB Source

[1]: Column "veckodag" cannot convert between unicode and non-unicode string data types. Package.dtsx 0 0*

if you try "cast (datename(dw,datum) as nvarchar(10)) as veckodag" what happens? — Dan S, Nov 09 '09 at 17:11
Thanks Dan that was the rub I changed the cast to nvarchar and then added a Data Transformation — salgo60, Nov 10 '09 at 18:35

score 2 · Accepted Answer · answered Nov 09 '09 at 19:15

2

In SSIS use "Data Conversion Transformation" inside data flow

answered Nov 09 '09 at 19:15

Damir Sudarevic

I have tested that but I get still an error.. I will do a new test – salgo60 Nov 09 '09 at 21:33
Cast it as nvarchar(10) and then go through the transformation. – Damir Sudarevic Nov 09 '09 at 22:10

1 Answers1