SQL Batch In Data Flow

I am learning SSIS, I am try to figure out how to run a SQL batch that returns a result set and export it to Excel using a Data Flow. I am using a OLE Db Source with a SQL batch shown below and the Destination Query is an Excel file.

How is this done?

So far I have had no luck getting the tasks to run. I need more than just simple queries.

The SQL is below:



SET NOCOUNT ON

DECLARE Tables CURSOR FAST_FORWARD FOR
SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE != 'VIEW'

DECLARE @RowCount INT

DECLARE @TableSchema NVARCHAR(128)
DECLARE @TableName NVARCHAR(128)
DECLARE @SqlCmd NVARCHAR(1024)

CREATE TABLE #temp ([Name] NVARCHAR(128), [RowCount] INT)

OPEN Tables
FETCH NEXT FROM Tables INTO @TableSchema, @TableName

WHILE @@FETCH_STATUS = 0
BEGIN
SET @SqlCmd = 'SELECT ''[' + @TableSchema + '].[' + @TableName + ']'', COUNT(*) FROM [' + @TableSchema + '].[' + @TableName + ']'
PRINT @SqlCmd
INSERT #temp EXEC sp_executesql @SqlCmd
FETCH NEXT FROM Tables INTO @TableSchema, @TableName
END

SELECT * FROM #temp

CLOSE Tables
DEALLOCATE Tables

DROP TABLE #temp