ssis

• munnaonly

  SSC Journeyman

  Points: 82

  More actions

  June 23, 2010 at 1:19 am

  #143833

  Hi,

  Server 1:

  database with tables and foreign key relationships.

  Server 2:

  database with tables and foreign key relationships.

  Execute a "Transfer SQL Server Objects Task" to transfer the tables from Server 1 to Server 2. Set the following options:

  DropObjectsFirst - True

  CopyData - True

  ExistingData - Replace

  CopySchema-True

  IncludeDependentObjects-True

  CopyAllObjects-False –only selected table

  ObjectsToCopy - Select the tables described above only.

  Security - All options False

  Table Options - All options true

  Please find the Following Error

  [Transfer SQL Server Objects Task] Error: Execution failed with the following error: "ERROR : errorCode=-1073548784 description=Executing the query "IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[tbl_mytest]') AND type in (N'U')) DROP TABLE [dbo].[tbl_mytest] " failed with the following error: "Could not drop object 'dbo.tbl_mytest' because it is referenced by a FOREIGN KEY constraint.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}"

  Thanks in Advance

  rehan

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  June 23, 2010 at 5:54 am

  #1183863

  Although the answer is mentioned directly in the error message, you can also find it here:

  http://www.sqlservercentral.com/Forums/Topic941566-148-1.aspx

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