Post reply

Error for use object temporal in Dataflow

  • November 10, 2010 at 9:00 am

    #143341

    Hi everybody, I have a package with a Execute task that create the table TMP_FILEFD_PAGOSPOS and after a data flow 'Carga cabecera en TMP_FILEFD_PAGOSPOS' with a OLE DB Destination to this table, TMP_FILEFD_PAGOSPOS, but when close the data flow show a error because don't exists the table. The last step of package is a Execute Task with the code DROP TABLE TMP_FILEFD_PAGOSPOS. How I can do it for fix the error?

    Thanks by your help,

    Error at Carga cabecera en TMP_FILEFD_PAGOSPOS [OLE DB Destination [1883]]: An OLE DB error has occurred. Error code: 0x80040E37.

    An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E37 Description: "Invalid object name 'dbo.TMP_FILEFD_PAGOSPOS'.".

    Error at Carga cabecera en TMP_FILEFD_PAGOSPOS [OLE DB Destination [1883]]: Failed to open a fastload rowset for "[dbo].[TMP_FILEFD_PAGOSPOS]". Check that the object exists in the database.

    Error at Carga cabecera en TMP_FILEFD_PAGOSPOS [DTS.Pipeline]: "component "OLE DB Destination" (1883)" failed validation and returned validation status "VS_ISBROKEN".

    Error at Carga cabecera en TMP_FILEFD_PAGOSPOS [DTS.Pipeline]: One or more component failed validation.

    Error at Carga cabecera en TMP_FILEFD_PAGOSPOS: There were errors during task validation.

    (Microsoft.DataTransformationServices.VsIntegration)

  • November 10, 2010 at 9:03 am

    #1248959

    Set the DelayValidation property of the dataflow to True. Furthermore, see that the table exists when you configure your dataflow.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 10, 2010 at 9:26 am

    #1248990

    Thanks a lot da-zero! This is the solution!

  • November 10, 2010 at 11:42 am

    #1249084

    Lisset (11/10/2010)

    Thanks a lot da-zero! This is the solution!

    No problem. Glad to help and that it all worked out.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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