DSXchange

Posted: **Mon Apr 19, 2010 12:23 pm**

Hi,

Parameter set name :test
parameters in parameter set :schema

Used in SQL of RDBMS stage as

test.schema

When i check the data by "view data" it works fine and I can see the data as well.But when i execute the job an error is occurred as below.

Dynamic_RDBMS_0,0: Info:

Code: Select all

jobname.Dynamic_RDBMS_0: SELECT CoCd FROM #test.schema#.table

the parameter is not resolved into a value.

Appreciate your help.

Thanks,
Elias.

Posted: **Mon Apr 19, 2010 2:08 pm**

When you mark a topic as resolved, our expectation (to help future searchers) is that you make a post explaining how it was resolved.

Posted: **Mon Apr 19, 2010 2:27 pm**

Not resolved as much as superfluous because it was (I assume) an accidental double-post. Really should have just deleted it before someone (or two someones) replied to it.

Posted: **Mon Apr 19, 2010 2:45 pm**

ya it was a double post, but i could not find a way to delete this post.Please throw some light .

Anyways if you know the solution please let me know.

Thanks,
Elias.

Posted: **Mon Apr 19, 2010 2:49 pm**

The option is there in the upper right-hand side of any post that you have made: Delete this post up there with Reply with quote and Back to top. As long as there's no replies yet.

DSXchange

parameter set issue

parameter set issue