Hi Guys,

I actually designing a workflow where in one task a sql action create/update an dataset with information that i need in another task of the workflow. So i create two datasets (dtnid1 and dtnid2) in the workflow designer. Then i add the task where the SQL statement updates the dataset and added there in create and populate dataset dtnid1. In the following task there is an loop action for this dataset (dtnid1).
I start the workflow and in the second task i got an error that the variable/dataset are not existing. I checked a sample task where the shared dataset is used (workflow loop). So far it looks identicly (without the loop action).

So where is mistake?

Regards
Timo

I quickly tested this and it worked good.

1. Added a dataset called dtnid1 in Workflow designer.
2. Created a task with this code that is running on one machine

<AMFILESYSTEM ACTIVITY="get" MODE="folder" SOURCE="c:\spool\" RESULTDATASET="dtnid1" FILEPROPERTY="fullname" />

3. Added a second task running on another machine. Added this code:

<AMLOOP ACTIVITY="dataset" DATASET="dtnid1">
<AMSHOWDIALOG>%dtnid1.FullName%</AMSHOWDIALOG>
</AMLOOP>
<AMFILESYSTEM ACTIVITY="write_file" FILE="c:\temp\dtnid1.txt">%dtnid1(2).FullName%</AMFILESYSTEM>

The second task both displayed the datasets data in the loop as well as wrote the data to the file outside the loop.

Maybe you have a type or something somewhere?