July 17, 2009 at 1:30 pm
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
July 20, 2009 at 12:53 pm
Never mind. Found my problem, and it was not a problem with the transfer object (byut the warnings are still there)
March 19, 2010 at 9:52 am
I know its been awhile, but do you remember what you did to fix this issue. I'm running into the same thing.
March 19, 2010 at 9:59 am
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.
March 19, 2010 at 10:00 am
Basically, All I'm trying to do is merge all the data from Stage to TEST on ServerA.
Please Help..
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply