parameter set issue

elias.shaik · Post by **elias.shaik** » 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.

ray.wurlod · Post by **ray.wurlod** » 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.

chulett · Post by **chulett** » 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.

elias.shaik · Post by **elias.shaik** » 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.

chulett · Post by **chulett** » 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.