Have you tried following steps:

Fix/WorkAround/Solution: Try all the suggestions one by one.

Suggestion 1: Make sure that on Mirror Server the database is restored with NO RECOVERY option (This is...

I think the SSIS only check file once, however you could use process monitor to check.

You may need to setspn for these two instances.

http://msdn.microsoft.com/en-us/library/ms191153.aspx

Here is one example, you could modify this script accordingly.

Create TRIGGER [dbo].[Tr_Test_Table_Audit]

ON [dbo].[Test_table] FOR INSERT, UPDATE, DELETE NOT FOR REPLICATION

AS

-- SET NOCOUNT ON added to prevent extra result...

error: "Cannot bulk load because the file could not be opened. Operating system error code 5(Access is denied)

It seems your SQL Service account couldn't access your file. Make sure you...

Thanks, i will try later. Have a nice day!

Is the database registry changed? can you show me which registry?

I have the same problem and not figure out what happened. Thanks!

Thanks for the reply. Can you show me how to enable .NET tracing. Our application is not a Web application, it is a client application published with Citrix.

1) create a new table with the correct datatype (BIGINT) for the column in question;

(2) load the new table with the data from the original table in chunks; that will...

You can try this:

When you first print something you are asked to download and install RSClientPrint.dll. This library resides in c:\windows\Downloaded Program Files. For some unknown reason this file...

You should incease the column, such as from varchar(10) to varchar(50), sorry to make you confused. 🙂

Found this: repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB

Becuase repair_allow_data_loss could make data lost, so it is better to restore from an...

check this out:Col002" (30)" failed because truncation occurred, you meed need add more space for this column.

It seems metedata issue and i got the same problem before and finally restore to the same version the export data to higer version.

I got the same problem before and finally restore to the same version then export data to the higer version.