Showing posts with label copying. Show all posts
Showing posts with label copying. Show all posts

Monday, March 19, 2012

Error on copying the database

Hi guys,
I can't find what is wrong.
I am copying a database via DTS and I get an error mid way "Invalid object dbo.fx_get_role_from_ownerid". But the object does exist and it has benn in production for a while now.
Why would I get his error, if the object does exist?Sounds like a user defined function...|||it is, and it's there. Why would I get this error?|||On the face of it...I'd say the stupid Object Id is out of whack with the object name...

try and recompile the function...then try it...

Why are you using DTS instead of dump and restore?|||Hi,
I have recompiled the function and still get the error.
I am using DTS to copy all databases on the server to another server every week automaticaly.
Any other ideas?|||How often do you back up the databases?

Why not attach them...

Would be the fastest thing to do...

Wednesday, March 7, 2012

Error messages logging and copying.

Hi:

How can I copy the error messages when I execute a SSIS package?. The Progress tab or the Execution results tab both dont have the means to copy the results. I would like the errors to be output to a text file under a directory on my drive system (some thing like C:\SSIS\ExecResults.txt). Is this possible?. If so how do I configure my package to output the package execution results to a text file?.

Any help/suggestions/comments highly appreciated.

Thanks

AK

Right click the package control flow and select Logging. Create and configure text log provider to output events that you want to the text file.

Books Online has detailed instructions on this. By the way, we just release July update to BOL, it is worth download time:
http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en