Change the select statement to

SELECT ? = MAX(PolicyID) FROM dbo.FactPolicy

Then in the paramter mappings of the task set the mapping to the variable as an output type, that should then...

Please can you read through the second link in my signature below on posting code and data for the best help.

We would need the DDL of the tables along with...

You wont be able to create a clustered index on them two columns as your primary key is already clustered.

You would first need to drop your primary key and re-create...

The replace function will do what you need

UPDATE TableA SET Col1 = REPLACE(Col1,'£','')

For keeping the read-only copy up to date, could you not do a sort of make shift logshipping configuration, assuming that the recovery model is FULL or you are allowed...

in the subreport properties are you passing in the parameters from the parent report or some other values?

Could use an expression

=FORMAT(Today(),"dd/MMMM/yyyy")

Can experiment with the string format, just remember that capital M is month and lower m is minutes.

Only thing I can think of is to do your initial load and a second load to a different DB.

Then to sync, load into that different DB and use something...

Why leave the data in access, do a one time import to sql then point the access front end at SQL instead?

Maybe this will help

http://www.sqlservercentral.com/articles/Tally+Table/70735/

Also provide the deadlock graph if you have it, if not enable traceflag 1222 or use extendend events or a WMI query to capture the deadlock graph.

Hi.

If you would be so kind as to read the second link in my signature on posting code, we would required DDL of the tables views indexes and sample data,...

14420 is no TX backup of primary database, I suggest fixing why you cant take TX backups of the primary DB.

(Edit, got my 14420 and 14421 errors the wrong way...

Could also be a kerberos issue is the SPN's havn't been setup to allow double hopping.

Take a look at BEGIN TRY along with a BEGIN CATCH aswell as @@Error