Thanks yes that makes sense.

I just found this thread as well:

http://www.sqlservercentral.com/Forums/Topic946318-1526-1.aspx

Yes I think you're right. Powershell would be the way to go maybe?

Many thanks.

So would SQL 2008 R2 SP1 be the SP I would run over SQL 2008 R2 Express?

This came up on a Microsoft course I recently attended - 6234a Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services.

Apologies - my first post should have said db_owner (fixed database role) and not dbo (user). If a user DOMAIN\steve is a member of the db_owner database role then they...

Thanks - that's what I thought. The course was a bit misleading here then.

Thanks for the response which clarified a few thing for me. However, the course specifically said to add the user to the fixed database roles of db_owner AND db_securityadmin (not...

Thanks for the response. The issue turned out to be due to the Local Connection setting. Even though it said Local Connection, the original server name was still buried in...

Oh OK - so if an agent job is about to start it will be missed if the same job is still currently running.

thanks

Steve

Yes - I'm going to make one pass using a Script Component and send it to two destinations. The files aren't very large so there is no issue with processing...

Great - thanks.

Fantastic - all working with EPT...

Just tlike to thankyou for the time you spent on this yesterday. Sometimes it's easy to over complicate things with so many different options - the Execute Process Task seems...

Sorry - I can use Source\*.* but I can't figure out how to assign the Destination paths to the FST DestinationVariable. I need to somehow map the Object variable containing...