SQL Server -> MS Access -
07-26-2005
, 12:16 PM
Hello,
i've created a sql task that reads a datetime value from an sql server
table. I want to store it in an global parameter. In a follow up step (data
transformation), I want to use that parameter for the where condition of an
sql-query for the source of the transformation. Unfortunately this is an
Access DB. The query is like that:
select * from messagetrackingentry where mt_loggedtime > ?
where I want to use the formerly feet global parameter.
All attempts leed to a 'catastrophic failure'.
Any help would be very appreciated ... |