"SUNNY" <anonymous@discussions.microsoft.com> wrote in message
news:08d801c3c956$4a632d90$a301280a@phx.gbl...
> Hi I created a simple stored procedure
>
> CREATE PROCEDURE testproc (@p1 int,@p2 int,@p3 int)
> AS
> BEGIN
> SET @P1=10+@P1
> PRINT @P1
> END
>
> Now In my DTS Pkg I have Execute SQL Task which has the
> following statment
> EXEC testproc ?,?,?
> And my parameter1 is assigned to p1 which is a global
> variable of value 10
>
> I am getting the following error
>
> The task reported failure on execution
> Invalid charater value for cast specification
>

<anonymous@discussions.microsoft.com> wrote in message
news:087201c3c95c$5be3b610$a401280a@phx.gbl...
> All of them are integers
>
> Sunny
> >-----Original Message-----
> >What datatype is the Global Variable ?
> >What are you passing to @p2 and @p3 (default i.e. no
> value is '' i.e. empty
> >string)
> >
> >--
> >
> >----------------------------
> >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
> >
> >
> >
> >"SUNNY" <anonymous@discussions.microsoft.com> wrote in
> message
> >news:08d801c3c956$4a632d90$a301280a@phx.gbl...
> >> Hi I created a simple stored procedure
> >>
> >> CREATE PROCEDURE testproc (@p1 int,@p2 int,@p3 int)
> >> AS
> >> BEGIN
> >> SET @P1=10+@P1
> >> PRINT @P1
> >> END
> >>
> >> Now In my DTS Pkg I have Execute SQL Task which has the
> >> following statment
> >> EXEC testproc ?,?,?
> >> And my parameter1 is assigned to p1 which is a global
> >> variable of value 10
> >>
> >> I am getting the following error
> >>
> >> The task reported failure on execution
> >> Invalid charater value for cast specification
> >>
> >
> >
> >.
> >