locked
Why does BI "Transfer SQL Server Objects Task" error occur? RRS feed

  • Question

  • I'm using SSIS to copy all tables and the data from server1 to server2.  Database names are same on both source and destination servers. dbo.MyTable definately exists in the source so I don't understand this error message:

     [Transfer SQL Server Objects Task] Error: Execution failed with the following error: "ERROR : errorCode=-1071636471 description=SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E37. An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E37  Description: "Invalid object name 'dbo.MyTable'.".  helpFile=dtsmsg100.rll helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C}".

     There's nothing fancy about MyTable:

    CREATE TABLE [dbo].[MyTable](

    [MyId] [int] NOT NULL,

    [ApplicationId] [int] NOT NULL,

    [RoleName] [varchar](50) NOT NULL,

    [NextMyId] [int] NULL,

    CONSTRAINT [PK_MyTable] PRIMARY KEY CLUSTERED

    ([MyId] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY]

     

    So why am I getting this error? If I run this create statement in a query window, logged in as same user, I do not get an error. So what is the cause of this OLEDB error?

    Monday, October 11, 2010 8:34 PM

Answers

All replies

  • try to set CopySchema to True and try again

    http://www.rad.pasfu.com
    • Marked as answer by MGS66 Monday, October 11, 2010 10:33 PM
    Monday, October 11, 2010 8:44 PM
  • Hi, 

    I am new to ssis , i am trying to Deploy my package to SQL Server and when i try to execute it from Integration Services in SSMS, i am getting the following error, can any one help me out with this issue

    Error: SSIS Error Code DTS_E_OLE DB ERROR. An OLEDB error has occurred. Error code: 0x80040E37. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E37 Description: "Invalid object name"

    Error: Failed to open a fastload rowset for "[Pakage Name]".Check that the object exists in database.

     

    Error: "component "OLE DB Destination"(64)" failed validation and returned validation status "VS_ISBROKEN".


    Monday, December 17, 2012 2:28 PM
  • How is this question related to the thread?

    I suggest you crate your own un-answered question.


    Arthur My Blog

    Monday, December 17, 2012 2:42 PM