Hi. I'm trying to access a parameterized stored proc as a source for a data
pump task. My SQL statement is as follows:

sp_mystoredproc ?

I then assign a global string variable with the value I would pass, but when
I try to preview data, the interface keeps coming back with:

"no value given for one or more required parameters". If I go stratight to
the transformations I have no columns in my source.

This is the second issue today I've been beating my head against the wall
with and I need a second perspective.

If I put the parameter directly in the SQL like:

sp_mystoredproc myparameter

everything works normally.

ANY IDEAS? I can't find any mention of bugs anywhere...

Thanks...Skip

Have you had a read of this

Global Variables and Stored Procedure Parameters
(http://www.sqldts.com/Default.aspx?234)

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Skip Borland" <skip.borland (AT) eig (DOT) com> wrote