Post reply

Error on scheduling the SSIS Pkg using SQL Job

  • July 9, 2007 at 3:27 am

    #117831

    Hi,

    I created a SSIS Package that seems to be fine while running from Microsoft Visual studio 2005. But it gives the following error message while running through SQL jobs.

       Description: Retrieving the file name for a component failed with error code 0x1B2CDC48.

    Any reason why?

     

    Thanks

     

  • July 9, 2007 at 7:36 am

    #718028

    In SQL Server 2005, you need to go through the security layer in order to run the job.

     

    The logic is like this:

    Ø      The job executor account needs the roles of sysadmin,  SQLAgentUserRole, SQLAgentReaderRole,  SQLAgentOperatorRole

    Ø      The job needs to be run under Proxy account

    Ø      The job executor account is better to be used to create SSIS package and so you are sure the job executor account has the right to run this SSIS package.

    Thanks,

    Viji Mahendran.

Viewing 2 posts - 1 through 2 (of 2 total)

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