Video Screencast Help

Workflow SQL Component

Created: 07 Sep 2012 | 3 comments

I want to use the default SQL component to run a simple select query against a DB and return the results. I do not want to build a custom SQL componet for this. The results are returned in a data set call computers with data type (Data Row[]). However the Computers variable never shows up when I try to use the For Each Item compenent next. I select Data Row as my type but no variables exist with that type?????

Comments 3 CommentsJump to latest comment

reecardo's picture

It could be a DataRow from a different namespace. Right click and get the basic help of the SQL component to (hopefully) get the full type (with namespace).

Also, verify that your component is returning a full array, and not just a single type.

rhamner's picture

When you 'Browse Data ' down stream of the component do you see properties on the data type? If not, change Output type to Rows or Variables and click the preview button. Then click the Populate Variables button. After that you can change it back to Rows only.

Like the warning says when you drag the component onto the screen, I strongly suggest you use the component generators. This component was meant to be replaced by the generators which means that I will likely be deprecated in the future.