Post reply

SQL Job does not executes SSIS package but Job goes to executing state and don’t stop.

  • July 22, 2013 at 4:17 am

    #296653

    Hi,

    There is one SSIS package which is executed successfully when run from

    Visual Studio. When the package is executed through SQL job using proxy

    account the job does not executes the package but Job goes to executing state and don’t stop.

    Please help me with some solution.

    Thanks and Regards,

    Nikhil Desai

  • July 22, 2013 at 4:45 am

    #1634393

    What do you do inside the package?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • July 25, 2013 at 3:00 am

    #1635640

    Hi,

    My Package basically imports flat file and process the data :

    My Source of Falt file is Microsoft Outlook. I recive mails from some ID's which have flat files as attachment . i use some vb script to export the flat file from the mails and save them on the local folder. then for importing i m using Data flow task and then one SP runs which process my data.

    Thanks and Regards,

    Nikhil Desai

  • July 25, 2013 at 3:06 am

    #1635642

    Might be a permission issue. Which account do you use in the SQL agent job?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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