Hello,

An application .Net has to run a DTS package.
This DTS package uses a step as followed:
Execute SQL Task : execute a stored procedure with
parameters.

The problem is that the parameters of the stored procedure
are using global variables, and .Net encounters some
problems with them :
exec myStoredProcedure ?,? => failure

If we remove the Global Variables from the DTS package
Properties, and hard code the parameters, it works :
exec myStoredProcedure 10, 2003 => success

But in any case, the DTS runs successfully in Entreprise
Manager with or without any global variables.

Thanks for your reply,
Regards,
Sophie BELAN

How are you calling the package ? Are you passing in values to the package
for the Global Variables and when you do this through .Net it fails but in
Designer it works?

Have a look at this

DTS Global Variables and Visual Basic .Net
(http://www.sqldts.com/default.aspx?265)

--
--

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

"sophie.belan (AT) eur (DOT) crowncork.com" <anonymous (AT) discussions (DOT) microsoft.com> wrote
in message news:012d01c3ba8a$f7d2daf0$a301280a (AT) phx (DOT) gbl...