SSIS package execution error.

  •  

     

    Is it problem with query or connection string? please let me know your thoughts!

    The error is from all executions report and SSIS package was being run via agent. So, bad code is my thoughts at this point.

    --ERROR

    Update salary band indicator column:Error: Executing the query "

    update X

    set X.pay_band_pointer=drd.val..." failed with the following error: "Invalid object name 'dbo.packagename'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Regards!

  • did you configure your connections after deploying the package or are you hitting your dev connections?

    account have access to those tables?

  • Do you actually have a database table called dbo.PackageName?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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