No expression editor and how to add todays date in an integration

  • 14Views
  • Last Post 24 April 2020
0
votes
Peter Alvestal posted this 23 April 2020

Hi, it says in the documentation that when creating an integration I can use expression, and then click to get up an expression editor. That does not work as I cannot see any editor-button at all.

 

My real issue was that I have a date column in my target database, where i want to import the date or timestamp of when the import is done. I tried different options but it does not work and as the expression editor does not exist, maybe I can get some suggestion from here instead.

0
votes
Mariia Zaharova posted this 24 April 2020

Hello Peter,

 

At the moment, Expression Editor is available only in old Skyvia UI.

 

As for the new UI, we are working on the Expression Editor at the moment and are doing our best to release it as soon as possible.

 

My real issue was that I have a date column in my target database, where i want to import the date or timestamp of when the import is done.

You can use an expression mapping with the GETDATE() function for this column in an import package. For more information, please refer to

https://docs.microsoft.com/en-us/sql/integration-services/expressions/getdate-ssis-expression

 

Best regards,

Mariia

Close