Variables In OLE DB Source

Hi,

I'm having an issue where it does not look like my variable is getting passed in with my source query. I have a date in a variable (which I have checked with a breakpoint to determine that it is getting set) and I am attempting to limit my query based on this date.

The query in the OLE DB Source is as follows:

SELECT
a.TransactionNumber,
d.StoreCode,
cast((convert(varchar, a.[time], 102) + ' ' + substring(convert(VARCHAR, a.[time],8), 1, charindex(':', convert(VARCHAR, a.[time],8))-1) + ':00:00') as datetime) as Time,
a.CashierID,
c.ItemLookupCode AS PLU,
b.FullPrice,
b.SalesTax,
b.Quantity,
b.Price
FROM
[Transaction] a
JOIN
TransactionEntry b
ON
a.TransactionNumber = b.TransactionNumber
JOIN
Item c
ON
b.ItemID = c.ID
JOIN
Store d
ON
a.StoreID = d.ID
WHERE
a.Time >= ?

In the 'parameters' window I have set up a mapping where Parameter0 maps to the User:LastTransactionDate parameter.

However, this does not seem to be applied and I always get ALL records back from the source table as if there were no WHERE statement at all.

Anyone have any input on this? Am I missing something obvious?

Thanks