0
Reply

SSIS table creating with STATIC data

Jacqelyn Lambert

Jacqelyn Lambert

Mar 22 2013 12:16 PM
1.2k
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!