Additional Column in date format

New Contributor

Hi 

I have a copy activity 

 

Source=MySql DB

Target=SQL Server Azure 

 

On my source I have added an additional Column using this expression:

 

@formatDateTime(utcNow())

 

but the resulting target tabel in the SQL Server is Nvarchar(max()) - that a string. 

I set the sink side up to crate the table if not exist and I drop the tabel every time I run the flow. 

 

Can you help me out? 

 

Regards, 

Christian

 

 

 

Christian_Hoffmann_0-1618237766083.png

 

0 Replies