SSIS table creating with STATIC data
Is it possible to create a table as shown in SQL query below in SSIS without a connection to a database? I am new to the environment and don't want to go down the wrong road.
CREATE TABLE #Reporting_Matrix ([Client] Char (5), [Investor_Number] char(5), [Investor_Name] char(65) )
insert #Reporting_Matrix ([Client] , [Investor_Number] , [Investor_Name] ) VALUES ( ' ', ' ', ' ')
insert #Reporting_Matrix ([Client] , [Investor_Number] , [Investor_Name] ) VALUES ( ' ', ' ', ' ')
insert #Reporting_Matrix ([Client] , [Investor_Number] , [Investor_Name] ) VALUES ( ' ', ' ', ' ')
insert #Reporting_Matrix ([Client] , [Investor_Number] , [Investor_Name] ) VALUES ( ' ', ' ', ' ')
insert #Reporting_Matrix ([Client] , [Investor_Number] , [Investor_Name] ) VALUES ( ' ', ' ', ' ')
insert #Reporting_Matrix ([Client] , [Investor_Number] , [Investor_Name] ) VALUES ( ' ', ' ', ' ')
etc.
Thank you!