Expand my Community achievements bar.

SOLVED

SQL Data Management Activity Issue

Avatar

Employee

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,

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.


     Manoj
     Find me on LinkedIn

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

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.


     Manoj
     Find me on LinkedIn

Avatar

Administrator

Hi @RRafiki,

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

Thanks!



Sukrity Wadhwa