How to take shortcut and kill 90 min troubleshooting

Create a view in SQL with name delegation tasks with no names
Create a script in AETL and be smart to ensure to write select * from [basecamp].[delegation tasks with no names]

Create a package with purpose to read all records in view, connect python script to remove assignee names and update the same in Sql with script

Create a new package,TO SAVE TIME, drag the script directly to package , connect script , script fails

Troubleshooting begins
1. Go back to SQL script and see the name of view, run it once , get OK , move back.
2. Run package again , and failure again at script 
3. Curse Chatgpt , read script again , everything feels fine
4. Change view name to delegation_someday. Feel smug , Curse AETL team to create such fickle software full of bugs
5. Run script , works
6. Run package, it fails again 
7. Drag Dynamic Display message , check if variables are coming through , run package variables are not coming through 
8. Play with Dynamic display message in settings regarding variables -> true /false , run package again , fails
9. Curse AETL team , drag old display message , that works all the time , check variable being read , it fails again
10. Go back to script , turn on variable replace , curse yourself , then curse AETL team to not make it a default option
11. it fails again , wonder . Curse AETL team again , restart AETL 
12. Run package , it fails again , 
13. Curse AETL team ,restart server. Package fails again 
14. Let's Simplify the script, write select * from [basecamp].[delegation]. Script works fine
15. Package fails again 
16. scratch head ,start to wonder where is the use # for variable settings , 
17. delete package , create new package , to troubleshoot, it fails again 
18. frustration rises. 75 min have passed now , why is such a simple script failing 
19. Curse AETL team again , such fickle software 

20. Realise I shouldn't have dragged the script , should have select LOOP Database , it works now 

aaaaaaaaaargh


 

I feel so cursed and puzzled now.
We are happy to assist you in away to make it easier. 

 

admin wrote:

I feel so cursed and puzzled now.

We are happy to assist you in away to make it easier. 

 

hahaha , it's all working now once I swapped the sql script action with database loop !! all my effort to save few precious seconds