Home Forums SQL Server 2014 Development - SQL Server 2014 stored procedure that inserts and updates a table with excel data RE: stored procedure that inserts and updates a table with excel data

  • June 14, 2014 at 3:18 pm

    #1721770

    +1 for SSIS

    You can implement the SSIS Catalog (SSISDB) in SQL Server 2014 and execute a Package from within your own stored procedure using stored procedures provided within the SSISDB.

    Deploy and Execute SSIS Packages using Stored Procedures - SQL Server 2014

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato