I'm using a "Transfer SQL Server Objects taks". These are the settings I have:

SourceConnection: ServerA

SourceceDatabase: Stage

DestinationConnection: ServerA

DestincationDatabase: TEST

DropObjectsFirst: False

IncludeExtendedProperties: True

CopyData: True

ExistingData: Append

CopySchema: True

UseCollation: True

IncludeDependentObjects: True

CopyAllTables: True

CopyAllViews: True

CopyIndexes: True

CopyTriggers: True

CopyFullTextIndexes: True

CopyPrimaryKeys: True

CopyForeignKeys: True

Error Message:

" failed with the following error: "There is already an object named 'tableName' in the database.". 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}".

Task failed: Copy SQL Stage DB Objects to TEST

Warning: 0x80019002 at CopyPrimeStageToTest: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

SSIS package "CopyPrimeStageToTest.dtsx" finished: Failure.