Hi,

In my DTS, I am using ActiveX Script to call SP. The reason I am using
ActiveX to call SP is I have to porcess many XML and load into SQL Server.
Here is my probelm

My Connection to SQL is works fine using ADODB, When I try to
call SP using Paramters that I am having problem. With out Parameter I am
able to excute SP.

When Include this line "Cmd.CommandType = adcmdStoredProc" than My process
fails with error messgae like "Arguments are wrong type or are out of
acceptable range "
set cmd.ActiveConnection= conn
Cmd.CommandType = adcmdStoredProc
Cmd.CommandText = "byroyalty"
cmd.Parameters.refresh
cmd.Parameters(1) = 10
cmd.Execute

What Do I need to change to call SP with paramters from ActiveX script ?

Thanks
-Kris

Have you tried

Cmd.CommandType = 4

?


"Kris" <Kris (AT) discussions (DOT) microsoft.com> wrote