Query does not return any results

Question

Hello,

I am running the following query on SSIS on the AdventureWorks2012 database..

select
c.CustomerID as CustomerAK,
p.Title,
p.FirstName,
p.MiddleName,
p.LastName,
p.Suffix,
em.EmailAddress
from Sales.Customer c
join Person.Person p
on c.PersonID = p.BusinessEntityID
left join Person.EmailAddress em
on p.BusinessEntityID = em.BusinessEntityID
where
(em.ModifiedDate > ?
OR p.ModifiedDate > ?)
AND (
em.ModifiedDate <= ?
OR p.ModifiedDate <= ?
)

Does anyone know why no results are returning?

Another thing, does anyone know what it means "Question Mark >?" ?

Thank you.

Answer 1

You need to do the following:

1. Create four SSIS variables
2. Assign their values
3. Map those variables in the SSIS Task (Execute SQL or OLEDB Source Adapter, etc.)

Answer 2

Hi Edgar Toia Neto,

May I know where do you run the sql query?

1.If in Execute SQL Task, please refer to the following link and pictures:
Parameter names and markers in Execute SQL Task.

2.If in OLEDB source, please refer to the following link and pictures:
To map a query parameter to a variable.

Best Regards,
Mona

---

If the response is helpful, please click "Accept Answer" and upvote it.