Post reply

SQL job issue with Truncate table

  • May 8, 2009 at 11:02 am

    #137367

    Hi

    All

    Back again with one issue

    I have package that truncate the table on local server before it does anything. That package is scheduled to run as using operatingsystem(cmdexec) inside job.While running as job its giving me error while truncating table, but when the package is run by itself or using VS2005 it will succeed without any error. The problem i am having is, there is not enough error when the job failed running the package,it will just say, step failed while truncating and at the same time it will run fine run independently.

    Any body knows how to debug this issue

    Thanks

    Simon

  • May 11, 2009 at 7:17 am

    #992085

    simon phoenix (5/8/2009)

    Hi

    All

    Back again with one issue

    I have package that truncate the table on local server before it does anything. That package is scheduled to run as using operatingsystem(cmdexec) inside job.While running as job its giving me error while truncating table, but when the package is run by itself or using VS2005 it will succeed without any error. The problem i am having is, there is not enough error when the job failed running the package,it will just say, step failed while truncating and at the same time it will run fine run independently.

    Any body knows how to debug this issue

    Thanks

    Simon

    You have permissions issue somewhere. Do you use proxy account to run your job?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • May 11, 2009 at 10:27 pm

    #992623

    yes, it has something to do with Proxy account?

    If so , how do i work around?

    Simon

  • May 11, 2009 at 10:32 pm

    #992628

    simon phoenix (5/11/2009)

    yes, it has something to do with Proxy account?

    If so , how do i work around?

    Simon

    Review your proxy account, allocating additional database permissions for accomplishing the task at hand.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • May 11, 2009 at 10:54 pm

    #992635

    Truncate Table is a DDL command and not a DML command. As such your user/login will probably need something like the db_ddladmin role.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

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

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