Thanks for that info. I will have post the actual execution plan tomorrow as I am not currently in the office.

Regards

sauce1979

how would I apply the sp_refreshsqlmodule procedure? Whats is the syntax.

I ran a manual dbcc checkdb and the output is as follows.

Msg 8992, Level 16, State 1, Line 1

Check Catalog Msg 3854, State 1: Attribute (referenced_major_id=1977058079) of row (class=0,object_id=357576312,column_id=0,referenced_major_id=1977058079,referenced_minor_id=0) in...

HI sorry it does answer my query. I was answering the forum on my blackberry so I was away for sql client. I am back at the computer and it...

what i am trying to pull out is a dataset where I do not have duplicate records because, for example, the record has 'SS18' in code1 and 'SS18' in...

Sorry I was not clear in my initial explanation of the scenario. The suggestions given would work for the data in the example I gave. However what I want is...

thanks!!

Thanks for that. will try that. What is an incremental load?

Moving from informatices to the datawarehouse team in my dept

I have added an image to make my problem a bit more clearer. In the excel spreadsheet I want to add another field under the Total column which is the...

Cheers!! Much appreciated

I have realised why it wasn't working. I did not put the correct directory in the User::TemplateFile expression. Initially it was set to :

'ContractTerms_" + @[User::CurrentCode] + ".xls' .When...

I edit the connection manager and save it the erroris still there. For some reason once it has run. It will not allow ssis to acces the files. I am...

The tool tip says:

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted...

the file is definately closed.