SQL Data Management Activity Issue

Question

Hi Expert,
 
I hope everyone is doing well. I'm reaching out here to see if anyone knows if there are any issues/bugs with the SQL Data Management Activity, or if i need to refine the scripts to work with this Activity properly.
 
Within testing this activity, when i right-click on the wireframe and "Display the Target" I see an error, and no data is displayed.  Upon viewing the List Configuration and removing the "Targeting Dimension (target) from the output column, the Primary Key does populate, and i am able to view the data.
 
When I try to script to collect other data, for example, I just want to view the emails from the database, I still receive an error, and no matter how I configure the output columns, I can never view the data.
 
My question would be is the SQL Data Management Activity working properly? 
 
Thanks,

_Manoj_Kumar_ · Accepted Answer

Hello @rrafiki

Try this:

Click on automatically create workflow checkbox and add a enrichment activity after SQL data management activity. Use the outbound transition from enrichment to check the interim data.

Sukrity_Wadhwa · Answer

Hi @rrafiki,Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.Thanks!

Sign up

Login with SSO

Login to the community

Login with SSO