Thanks
1)[Execute SQL Task] Error: Executing the query "EXEC ProcTPSUpdate @intJob = ? , @varCharUserName ..." failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems...

Thanks Phil - that seems to have solved it - I had @variable =  , whereas I now have just the value , and its working fine now.

Interestingly...

Task manager has it at 8 , 35% , 2%
L

in my expression do I set it as @variable to be set = "Value" or just "Value" - it...

Well for instance now - ive successfully set up the variables. Trying to drag the task onto the control tab - its hangs = not responding in title bar.

Thanks John - I'll give it a go - the first few are very instance specific - so I'll set them up first, and then see what the best solution...

Thanks John

This will be an idiots question , wont the SISS version be the same as the version hsoting the db. ie I'm limited to whats available at...

Sorry I should add that we want to do some changes to the indexes, which requires dropping the Fks anyway.

The db is small, biggest tables 1million or2 records, not...

Thanks - I'll look into it.

Thanks - just checked teh last instance which wasnt running - was set for automatic start on server and agent but hadnt been running, till I manually retsarted it?

Thanks Alan - I suppose this is something I should get the local network / support people to set up for me?

Any settings I can apply to make sure the...

You can use the wizard to creat new report then copy acorss the table.

Or again not great - work backwards in your column list, so yoiu are always adding to...

Cheers - your absolutely right - I have no idea why I thought otherwise - thanks - that solves that! 🙂

No dont need most parts of that - just the headers being teh header in the datasheet, ie replacing A , B , C etc

Sorry - what I mean is teh header is exported but as line one of data in excel. Since its teh header in SSRS i want it a the header/field...