Please post new questions in a new topic.

But here you go

http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/web.aspx

If using UNC path, then you need to ensure that the SQL service accounts have at-least read access to the network share to be able to access the file.

Are you using the UNC path or where you mapping a drive?

SSIS is not cluster aware.

http://msdn.microsoft.com/en-us/library/ms345193%28v=sql.105%29.aspx

Nope works out the box for me, no proxy account or anything needed as we are not behind a proxy.

Start a discussion on the codeplex site, someone might know how...

The geo data would be in a different API, so couldn't comment on that particular API, but the GA API using the codeplex solution works great, apart from the metrics...

We are using it to track statistics for our SaaS product, where we are developing a series of SSRS reports where the tennant can slice and dice the information as...

Not all metrics can be exported in 1 DFT, its trial and error, I started with 1 metric then added one in at a time until it wouldnt export then...

Create view requires CREATE VIEW permission in the database and ALTER permission on the schema in which the view is being created.

Also db_datareader will do for reading from all tables.

The object gets its collation from the database, so the database where you are declaring the table variable must be in a case sensitive collation.

The problem is with the ' in the casts

If you select out the @sql param you will see that it is

; WITH list_cte (table_name,field_name,fld_id,sql_value,field_value,exporttype) AS ...

But even in...

SP_RENAME will be a good friend on this one.

Create the table again, but with a different name, eg table2.

Do all your processing, truncating etc in table2

Then rename table1 to...

Restoring the encryption keys will have probably caused it as the keys are out of sync.

Two ways to go it, find the correct encryption key file or delete all encrypted...

This should also do the same

SELECT

[P/O Header].AccRef,

RIGHT('0'+CONVERT(VARCHAR,Products.SPM),2) AS SPMNo,

RIGHT('0'+CONVERT(VARCHAR,DatePart(ww,[Due Date])),2) AS [WKNo],

[P/O Header].OrdNo

FROM

[P/O Header]

INNER JOIN

[P/O Details]

ON

[P/O Header].OrdNo = [P/O Details].OrdNo

INNER JOIN

Products

ON

[P/O Details].StockCode...