SQL Parameter Syntax

Guys,

Wahts the right way to specify a parameter in an Execute SQL Task when
the param is a varchar? should I use apostrophe's around the ? or not?



I have two SQL tasks .. one where the query is specified like :



WHERE FIA.BaseCurrency = ?



Which SSIS likes and doesn't complain about...(the but then I
have another query.. [below].. which SSIS complains about unless I have
apostrophes around the ?



So its like:

AND FIA.BaseCurrency = '?'



So.. which should it be?



The problem for me here is that when I DO put the apostrophes around the ? I get no results back from the query...



PJ



The problem query:



SELECT ForeignCurrency, RateFromFile AS YesterdaysRate
--The ISNULL just protects us from situation where a rate is not found,
-- which could occur if the last loaded rates file was missing the rate for the
-- foreign currency we are checking.
FROM inputrates IR

WHERE fileheaderid in (
-- this gives the ID's last set of rates loaded on
-- whatever was the previous day (ie on a monday the previous load day was friday)

SELECT top 1 MAX(ID)
FROM FileInputAttempts FIA
WHERE Source = '?'
AND FIA.BaseCurrency = '?'
AND status = 'SUCCESS'

AND CAST(FLOOR(CAST(LoadDate AS
float))AS datetime) <= CAST(FLOOR(CAST(Dateadd(day,-1,getdate()) AS
float))AS datetime)
Group by CAST(FLOOR(CAST(LoadDate AS float))AS datetime)
order by MAX(loaddate) DESC
)