Hi and welcome to SSC, please could you follow the second link in my signature block and post the table definitions, sample data and your expected output of based on...

After changing my search terms fo SSIS Google Analytics some kind developer has written a plugin for GA which can be found here http://analyticssource.codeplex.com/. All you need to do...

HowardW (5/9/2012)

---

It would definitely be more elegant to use the Google Analytics API (this has .Net libraries you can download and it looks pretty simple to interface with), then use...

does this help

declare @results xml

set @results = (select name from sysobjects for XML AUTO)

select @results

the publisher and distibution server can be the same box, so that would...

is the database stored on many different computers or is it on one central server?

if its on a server and you want it to backup to a users workstation you...

the main thing to worry about is how often the table is updated as if you have set the FTC to be change tracking automatic then each update insert delete...

yes they are stored like any other index, you can query the space in the GUI by clicking properties of the FTC under the storage node in SSMS and look...

ensure that the account which is running the SQL service has the nessesary rights to write a file into the locations you wish for it to go.

To add on from the above, does the user exist in the database it needs to connect to.

If your using SQL authentication, has the DB been refreshed from a different...

firstly if you can get more drives added to the server

i've seen some people say that with the system databases (excl TempDB) that the MDF and LDF are ok on...

Express is limited to 1 socket or 1 physical CPU, so getting 2 CPU's isnt going to help.

In 2012 it is also limited to lesser than 1 socket...

might be a long shot but nothing automated restoring the database

select

destination_database_name,

user_name,

restore_date,

case restore_type when 'D' then 'Full Restore' when 'L'...

are you able to see the windows application event log to see if the error was logged there so we have something more to play on

you may have checked this but the targetserverurl of the solution is set to the report manager url? e.g http://servername/reportserver (that is assuming you have used the default installation...