February 28, 2020 at 5:43 pm
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!
February 28, 2020 at 6:12 pm
did you configure your connections after deploying the package or are you hitting your dev connections?
account have access to those tables?
February 28, 2020 at 6:52 pm
Do you actually have a database table called dbo.PackageName?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply