Stored procedures are not parameterized views

This post by Adam Machanic is one post every SQL developer should read.

And if you use SSIS (SQL Server Integration Services) in particular, this post by Jamie Thomson really explains what the heck Adam was talking about.