OK your article says:

In SSIS 2012, the unit of deployment is a project. This lets you deploy everything at once: all the packages, parameters and connection managers. This has,...

Oh, so whats the best way to deploy a package to an existing project in SSISDB?

Thanks both

Thats fixed it thanks, I had installed the 64bit ones but that hadn't worked.

Thanks again

Apologies - the error is:

Could not retrieve the table information for the connection manager 'Excel Connection Manager'.

Failed to connect to the source using the connection manager 'Excel Connection Manager'

and I...

Hi - yes I have found a property called Run64BitRunTime and set it to false however I still get the same error, which is was is leading me to believe...

OK thanks

Hi there thanks for the reply. The cube is processed by a SQL job so I can look at that. Out of interest I found this article on...

Thanks both for the replies 🙂

For example code look here:

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

However the last poster is right in saying you may need to backup your log first. You can check if your log can not be...

Yes its the same problem, the recommendation is usually to ignore fragmentation on indexes with less than 1000 pages, although I find in practice I am not worried on anything...

Always been a bug bear of mine to but there is no way round it. Just create a SQL login on the remote server and map to it. ...

In the GUI you can right click the database and go to tasks > Shrink and select either files or data

I managed to resolve this. I looked in the MSrepl_errors table and found an error of:

Message: Conversion failed when converting date and/or time from character string.

Stack:

It seemed the...

Hi Grant - Thanks for the reply.

We generally set the maximum memory and also lock pages in memory (I assume this stops the fluctuations you talked about).

If I...