SSIS Error:
[Execute SQL Task] Error: Executing the query "DECLARE @firstname VARCHAR(1000),@lastname VARCHAR..." failed with the following error: "Invalid object name 'dbo.Geography'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Fix:
Please check whether you are running in the correct database and whether the specified object is available in your database. I have changed the connection properties(database). It worked fine for me.
Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTechhttp://www.kaashivinfotech.com/