Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Transfer SQL Server Objects Task Expand / Collapse
Author
Message
Posted Friday, July 17, 2009 1:30 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 5, 2014 11:13 AM
Points: 219, Visits: 717
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
Posted Monday, July 20, 2009 12:53 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 5, 2014 11:13 AM
Points: 219, Visits: 717
Never mind. Found my problem, and it was not a problem with the transfer object (byut the warnings are still there)
Post #756118
Posted Friday, March 19, 2010 9:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 18, 2014 5:25 AM
Points: 148, Visits: 647
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
Posted Friday, March 19, 2010 9:59 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 18, 2014 5:25 AM
Points: 148, Visits: 647
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
Posted Friday, March 19, 2010 10:00 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 18, 2014 5:25 AM
Points: 148, Visits: 647
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 »

Add to briefcase

Permissions Expand / Collapse