January 20, 2014 at 12:12 am
When I try to execute my SSIS package in SQL server agent, an execute SQL task in my SSIS package fails. I get the error - 0xC002F210. The query works correctly in Management studio and even in SSIS. I checked everything and it seems fine. Yet, i get the error -
Code: 0xC002F210
Source: GetData Execute SQL Task
Description: Executing the query "SELECT [col_1]
[col_2..." failed with the following
error: "Invalid object name 'TableThatReallyExists'.".
Possible failure reasons: Problems with the query "ResultSet"
property not set correctly parameters not set correctly
or connection not established correctly.
End Error DTExec: The package execution returned DTSER_FAILURE (1)
That error is misleading. The table name is correct and it actually exists. How do I find out what is actually causing the problem. I don't know if I am missing something or if its a quirk of SSIS.
January 21, 2014 at 6:27 am
Have you checked the connection to make sure it is pointing to the correct database?
January 21, 2014 at 11:07 am
Scott Murray-240410 (1/21/2014)
Have you checked the connection to make sure it is pointing to the correct database?
yes it is correct. removed package configs and brackets around offending table. Works now. strange
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply