Daily Insert records into Table RRS feed

  • Question

  • User-883855585 posted

    I am running SQL Server 2008 R2.  I want to insert records into a table daily.  Not a bulk insert, just a few rows.  Something like:

    insert into tasks values(
    		'Daily Cleaning','Tech',convert(varchar(10),getdate(),101)+ ' 17:00',0,
    			null,null,convert(varchar(10),getdate(),101)+ ' 16:30', convert(varchar(10),getdate(),101)+ ' 17:00', null, null, null, null);

    Do I use an SSIS package or is there another way to do it?  In 2000 I used DTS and scheduled it to run nightly.


    Wednesday, February 24, 2016 6:16 PM


  • User77042963 posted

    The SSIS is the newer replacement of DTS. You can migrate or recreate your SSIS package from the way you did in your DTS package and setup a schedule for a job to run your new package.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, February 24, 2016 6:59 PM