USE SCHEMA TO CREATE TABLE INSERT DATA THEN CREATE EXCEL SPREDSHEET
Posted on 2011-03-21
I have a SQL Schema, Which i want to run using SSIS packages to insert the data into my database it includes all insert commands and is over 18,000 lines long so dont really want to copy it into here...
What im trying to do is get the package to run the SQL file (dont know which tool that is on the taskbar) create the database based on the schema given. (which includes syntax GO) and then create teh table and insert data..
Once its created i need it to extract 4 tables from table and insert these with the data into an EXCEL spredsheet is this possible?