In SSIS 2008 Is there a way for me to pass a constant to a stored procedure in a SQL Task tool without using a variable? Can I set a parameter to always be "Started" for example?
EXEC MyProc 'Started', ?
That doesn't work, but it is essentially what I'd like to do.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams