Post reply

How to run a script on every sunday

  • September 23, 2008 at 2:18 am

    #382780

    Hi,

    I would like to run SSIS automatically extract files from a folder for Integration services. It will be something like a batch service which should run on every sunday.

    How to do it?

    Thanks

    Regards,

    Viji

  • September 23, 2008 at 2:27 am

    #875478

    In SQL Server Management Studio, highlight SQL Server Agent -> Start. Highlight Job ->New Job…, name it , myJob.

    Under Steps, New Step, name it, Step1,

    Type: SQL Server Integration Service Package

    Run as: myProxy

    Package source: File System

    Browse to select your package file xxx.dtsx

  • September 23, 2008 at 5:27 am

    #875555

    Hi,

    Thanks for your reply. i've tried and getting error :

    Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)

    can you suggest your opinion on this.

    Thanks,

    Regards,

    Viji

  • September 23, 2008 at 6:14 am

    #875579

    hi ,

    check the below link for the creation of packages.

    http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx

    vijay

  • September 23, 2008 at 9:29 pm

    #876098

    Hi Vyas & Vijay,

    Thank you so much for your help

    Regards

    Viji

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply