How To Pass Table Variable Data Into A Data Flow In Ssis

I wrote a code like this in execute sql task Declare @tmpHistoricDriveSpace Table ( Servername varchar(255), MachineName varchar(255), Drive char(2), FreeSpace_MB int) insert int

Solution 1:

Instead of writing the code in execute sql task why can't you write it in OLE DB Source directly.

Thanks, Santhosh