Additional Column in date format

%3CLINGO-SUB%20id%3D%22lingo-sub-2267972%22%20slang%3D%22en-US%22%3EAdditional%20Column%20in%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2267972%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20copy%20activity%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESource%3DMySql%20DB%3C%2FP%3E%3CP%3ETarget%3DSQL%20Server%20Azure%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20my%20source%20I%20have%20added%20an%20additional%20Column%20using%20this%20expression%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%40formatDateTime(utcNow())%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20the%20resulting%20target%20tabel%20in%20the%20SQL%20Server%20is%20Nvarchar(max())%20-%20that%20a%20string.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20set%20the%20sink%20side%20up%20to%20crate%20the%20table%20if%20not%20exist%20and%20I%20drop%20the%20tabel%20every%20time%20I%20run%20the%20flow.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20help%20me%20out%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%26nbsp%3B%3C%2FP%3E%3CP%3EChristian%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Christian_Hoffmann_0-1618237766083.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F271989i136C4FA7137C312A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Christian_Hoffmann_0-1618237766083.png%22%20alt%3D%22Christian_Hoffmann_0-1618237766083.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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