Troubleshooting the cryptic error - 0xC002F210

  • 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.

  • Have you checked the connection to make sure it is pointing to the correct database?

  • 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