SQL Data Management Activity Issue

[RRafiki]

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 solution]

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]

Hi @RRafiki,

Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!