Creating SSIS package Error

  • I am trying export SQL Server 2005 std edition database tables(300) data to excel destination using Import/Export wizard. I selected the save package in SSIS. I am getting below error.

    Is there any limitations on tables...please advice

    - Prepare for Execute (Error)

    Messages

    Error 0xc0202009: Package_0707_02: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

    An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unspecified error".

    (SQL Server Import and Export Wizard)

    Error 0xc020801c: Data Flow Task: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DestinationConnectionExcel" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    (SQL Server Import and Export Wizard)

    Error 0xc004701a: Data Flow Task: component "Destination 64 - Entry" (4382) failed the pre-execute phase and returned error code 0xC020801C.

    (SQL Server Import and Export Wizard)

  • Hello SSIS experts,

    Any body reply to question please.

    I am trying to create SSIS package using Import/Export wizard

    exporting 300 tables data in to excel. getting error.

    Is there any limitations?

  • there will be some limitations based on no. of rows, should not exceed 65656, as in excel

    but having a look at your erro:DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "DestinationConnectionExcel" failed

    looks like there is connection problem

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

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

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