So, I had the AdventureWorks2008R2 database installed.

What i did instead of selecting the Persons.Contact Table, is:

Chose SQL Command

and Joined the 2 Tables that have the information as such:

USE AdventureWorks2008R2

SELECT P.FirstName, P.MiddleName, P.LastName, E.EmailAddress

FROM Person.Person AS P

LEFT JOIN Person.EmailAddress AS E

ON P.BusinessEntityID = E.BusinessEntityID

When I preview the information comes out as it's supossed to.

But when I run the SSIS Project, it creates the table, but it doesn't insert any of the data.

Can i get some guidance please?