使用SQL Server 2008 SSIS数据流通过带有数据源参数的过程从SQL Server 2005中检索数据

I was trying to retrieve data from a procedure on SQL Server 2005 and populate a table on SQL Server 2008. Packet is on SQL Server 2008. I have a SQL Task which I use to get the date. The result set is set to a variable called I was trying to retrieve data from a procedure