How to iterate through a List of SQL scripts, execute, and export data table to .txt file

[CScruggs (Cathy)]

Okay, thank you this makes sense now.
Question: Will each out text be a separate file (data table) or will it write each data table to one file? I need them to be in separate files so I can upload the data into another system.

[Palaniyappan (Forum Leader)]

Yes buddy you keep them to be separate files,

Cheers

[CScruggs (Cathy)]

I created a variable for the DataTable (outText), so how do I get the data into .csv format?

[Palaniyappan (Forum Leader)]

Buddy You have a activity called write csv activity that can take in the datatable and give out the csv file

Cheers…

[CScruggs (Cathy)]

I keep getting this run time error…what does it mean?

[Palaniyappan (Forum Leader)]

Where did you get this error buddy screen shot of workflow…

Cheers

[CScruggs (Cathy)]

When I ran the workflow.

[Palaniyappan (Forum Leader)]

Buddy pass as item in read text file instead of scripts as scripts is a array, thats why showing one or more errors

Cheers

[CScruggs (Cathy)]

I replaced the read text file with item (instead of script) and I get the error message. The output of read text is outtext, then I pass the outtext to execute query with the output datatable as DataOut, next I am taking DataOut as input to write CSV file with the path being the path to the output .csv files.

[CScruggs (Cathy)]

here are my variables…

[Palaniyappan (Forum Leader)]

what was the error buddy same or different

Cheers

[CScruggs (Cathy)]

same error message as above.

[CScruggs (Cathy)]

In the details of the error message it says it can’t find the file, which is the script file. I noticed in the screen shot the path is incorrect even though I have it correct in my variables.