Hi Guy,

I need some information.
In my DTS I want to use a traformation task with a stored procedure as
source. This step is ok.

THEN...

This SP need, for a correct function, 2 parameters that I want to set it
with 2 DTS global variables.

In task trasformation source, I write " EXEC RunSql ?,? " when I try to view
some data, DTS show me that it not have a parameter.
I press parameter button and I set 2 param with my 2 global variables.

But when I retry to visualize the data, the DTS give me the same error,
besides it doesn't create the map of the fields.

PS:
I would like to compose as a string the table from which I retrieve the data
as source of trasformation.

What can I do? Thare are any way?

Thanks.

Dario Concilio [MCP] wrote:
If you are using dynamic SQL inside the proc then it will probably choke
since it cannot determine the meta-data.

Use some SQL that gives the correct meta-data for setup, then change to
the real SQL afterwards. It should run fine, but design-time you have a
problem.



--
Darren
http://www.sqldts.com
http://www.sqlis.com