Record Difference In SSIS

Hi,

when I run this script on SQL Server Management Studio I get 50,000 records. If I run it in an SSIS package, it runs but I get 0 records returned. Why?

Please help.

Thanks,



Declare @year table
([Acreage] [varchar](5) NOT NULL,
[CurrentYr] [varchar](5) NOT NULL)

insert into @year values ('acres', '2008')




SELECT year.acreage, year.currentyr, property_char.property_id, ROUND(property_char.value,0) as PropID
FROM

property_char INNER JOIN
property ON property_char.property_id = property.id INNER JOIN
property_char AS pc2 ON property.id = pc2..property_id INNER JOIN
prop_valuation ON property.id = prop_valuation.property_id INNER JOIN
val_component ON property.id = val_component.property_id, @year as year


WHERE property_char.property_id < 81695 AND
property_char.property_id = property.id AND
property_char.prop_char_typ_code = 'SIZE'
AND
property_char.tax_year = '2008'
AND
pc2.prop_char_typ_code = 'USECD'
AND
(pc2.value not in ('85','86','87','88','95')
AND
pc2.tax_year = '2008' AND
pc2.property_id = property.id
AND
property.pact_code = 'REAL'
AND
(property.eff_to_date is null OR property.eff_to_date >= getdate())
AND
prop_valuation.property_id = property.id
AND
prop_valuation.tax_year = '2008'
AND
prop_valuation.local_assed_ind = 'Y'
AND
val_component.value_type = 'MKLND'
AND
val_component.property_id = property.id
AND
val_component.tax_year = '2008'
AND
val_component.modified_value > 0)
AND NOT EXISTS (Select 'z' from parcel_exclude where property.parcel_number = parcel_exclude.parcel_number AND special_assessment = 'CD')