The Automation Package is not able to fetch values from the variable in the Export Dataset

we assign all values in Automation package here.

trying to use those values in same package from Export Dataset.

Variables should work like that just fine. Here is a sample I've setup that also uses UNC paths as you have for REPORT_PATH.

Here is my machine running Toad. We can see the actions, the UNC path variable value, and my computer name to show that the variable path is to another server.

Here is the target machine. The file was created with the contents I expect.

Are you receiving any errors?

Michael