Problem With Dynamic Input For SQL Server

[amanda04]

I'm having this problem with Dynamic Input for Sql Server. I want to dynamically input a data source and a Select statement but when I run my workflow this error appears:

Dynamic Input (23): No table chosen; Please select a Table from data source

My input Data Source Template is:

odbc:DSN=Server1;UID=99999;PWD=__EncPwd1__

And I also input a table to select for test:

Idk what I'm doing wrong, is there a away to solve this issue?

[amanda04]

@CharlieS This is exactly what I need, I need to study more about macros to structure more this kind of needs.

Tks a lot!