DTS ? or actual value nightmare !!!

[NevG]

Hi gang

PLease- please help me with this

I have a DTS package that calls a sp that requires params. It so far looks like so:

spParamName ?,?,?,?

I have set up the params as defaults etc... however when I try to run the package it fails giving me the

"No value set for one or more paramaters" error

When I replace the ?,?,?,? with actual values it runs fine -

why cant I preview this execution when I have ?'s in place of params even tho the question marks are assigned values in the Paramaters properties page

Please help guys !!

Thanks

Nev G

 

[Coder7]

Try passing:


'','','',''