Passing in Variables into a Stored Prodedure

  • I'm trying to pass in 5 variables into a Stored Procedure from a DTS package. Within the DTS package I'm using ? marks to represent my variables. Currently, SQL Server is only letting my pass in 3 variables from the DTS package. Any input would be appreciated. Thanks!

    Edited by - jc1856 on 06/10/2002 1:35:31 PM

  • Can you create the variables and it just doesn't pass or you cannot do this even?

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • I can create the variables but when I try to execute...I type "EXECUTE [Stored Procdure Name] ? ? ? ? ? and I'll get an error after the 3rd question mark.

    Can you create the variables and it just doesn't pass or you cannot do this even?

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

    [/quote]

    Edited by - jc1856 on 06/11/2002 12:12:50 PM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply