Avatar

Correct answer by
Employee Advisor

Hi,

 

If you are trying to view the data being inserted then you can either perform a preview, or you can execute the workflow to the point where the enrichment runs, then simply right click on the output transition from the enrichment.  This will allow you to view the data and export it if desired.

 

When it comes to inserting the data, I would not recommend using the SQL Code activity but instead using the update data activity.  The SQL activity doesn't actually execute SQL within the activity itself but calls upon templates (see documentation below):

https://docs.adobe.com/content/help/en/campaign-classic/using/automating-with-workflows/action-activ...

 

Regards,

 

Craig

View solution in original post