Transfer SQL Server Objects Task

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Transfer SQL Server Objects Task

Transfer SQL Server Objects Task

Rate Topic

Display Mode

Topic Options

Author

Message

Rem70Rem

Posted Friday, July 17, 2009 1:30 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 2:47 PM
Points: 201, Visits: 649

When I use control flow "Transfer SQL Server Object Task", I always get a warning saying the object I want to transfer exist in the destination database even if I have set drop object fist.

The problem is I have this control flow included in a sub-package. When I run the parent package the return of the sub-package failed because these warnings. How I can set my package to bypass the warning?

Thanks,
Rem

Post #755101

Rem70Rem

Posted Monday, July 20, 2009 12:53 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 2:47 PM
Points: 201, Visits: 649

Never mind. Found my problem, and it was not a problem with the transfer object (byut the warnings are still there)

Post #756118

tan110

Posted Friday, March 19, 2010 9:52 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 30, 2013 12:56 PM
Points: 146, Visits: 613

I know its been awhile, but do you remember what you did to fix this issue. I'm running into the same thing.

Post #886520

tan110

Posted Friday, March 19, 2010 9:59 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 30, 2013 12:56 PM
Points: 146, Visits: 613

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.

Post #886524

tan110

Posted Friday, March 19, 2010 10:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 30, 2013 12:56 PM
Points: 146, Visits: 613

Basically, All I'm trying to do is merge all the data from Stage to TEST on ServerA.

Please Help..

Post #886527

« Prev Topic | Next Topic »

Permissions