MS SQL Server DTS - SQL Server -> MS Access

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL Server -> MS Access

Niklas

2005-07-26, 1:23 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 ...

Sponsored Links