Post reply

SQL Job to execute SSIS Package

  • January 26, 2009 at 9:58 am

    #932686

    It may be that, if you're using Windows authentication in the SMTP Connection Manager in the package, the SQL Agent account doesn't have access to the pdf files. Check the file security.

    Greg

  • January 28, 2009 at 1:58 am

    #933660

    Hi,

    I faced a similar problem and could not solve the authentication issue, but found an alternative way like creating a batch file running the SSIS package and schedule that batch file through windows task.

    In order to do that, first create a text file with something similar to the following commands in:

    "C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec" /f "path of package\package.dtsx"

    then save it with ".bat" extention.

    Then from the run of Windows start write Tasks, and schedule a task here to run the batch file on the intervals you want.

    Hope that helps as an alternative solution.

    Regards,

    Sahin.

  • August 31, 2011 at 10:02 pm

    #1375788

    can u please help me this in detail

  • September 2, 2011 at 8:27 am

    #1376460

    The error you have posted makes me believe that you are just giving the <filename> to look for. Give the full path of the file like "C:\MySourceFolder\MyFileName". That should help.

  • September 8, 2011 at 9:30 am

    #1378657

    after creating a .bat file .... how to schedule a task through windows scheduler

  • September 8, 2011 at 10:14 am

    #1378715

    You need to go to Task Scheduler in Accessories > System Tools.

    The interface is a bit different in XP and Win 7 but do the same job.

  • September 8, 2011 at 11:24 am

    #1378795

    thanks a lot.... i got it

Viewing 7 posts - 1 through 8 (of 8 total)

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