February 11, 2010 at 7:27 pm
Seems to be failing due to view not being in place already - surely a "copy database task" would allow for the creation of objects in non specific order?
Error: The Execute method on the task returned error code 0x80131500 (ERROR : errorCode=-1073548784 description=Executing the query "CREATE VIEW [dbo].[vw_ACAT_ONI_PLUS] ......
FROM CMEReporting.dbo.vw_CSAWLWithOni .....
" failed with the following error: "Invalid object name 'CMEReporting.dbo.vw_CSAWLWithOni'.". 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}). The Execute method must succeed, and indicate the result using an "out" parameter.
Is there a way to tell the wizard to ignore "object not found" type errors?
February 12, 2010 at 12:54 am
I assume you are using the Transfer SQL Server Objects Task.
I was hoping that you could ignore the error by raising the MaximumErrorCount property of the Task, but this seems not to work.
So your only option is to avoid the error (rather than ignoring it): either set IncludeDependentObjects to True in the Task Editor or use two tasks where the first task transfers the view and the second task transfers the object that refers to it.
TheTransfer Database Task is different in that it copies or moves the actual data and log files.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply