Thanks for posting back with the solution; it's always useful when people do that! 🙂

Ok, so no one uses the Deployment Utility to deploy SSAS projects then?

So, question: how do you deploy your 2012 SSAS projects in as automated a way as possible, particularly...

There is a custom component available on Codeplex that may enable you to achieve this:

http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652

Regards

Lempster

sneumersky (1/21/2014)

---

Careful when referencing the toolkit as well....make sure you also subscribe to design tips as well as, from time to time, the group will "overrule" or "modernize" their thinking...

I groan inwardly and then tell them I'm a fighter pilot! 😀

You can use a Raw File Destination in a Data Flow Task which writes data to a .raw file on the filesystem in SQL Server native format. You can also...

I'll go for the second option. 😉

It's not clear from your question whether you have the 'emp' and...

You're very welcome. 🙂

What does PITA stand for?

Is there anything in the SQL Agent log that might give you a clue?

Regards

Lempster

Hi Tim,

I wouldn't worry about that personally, but if you know that the Publisher database will be updated only at specific times then, yes, you could stop the Log Reader...

It's actually the Distribution database (via the Distribution Agent) that 'feeds' the transactions to the Subscribers so you won't get any contention by running the Log Reader agent on a...

There is nothing wrong with only running the Snapshot Agent at certain times. If there is nothing for it to do, i.e. you have not added or dropped any articles...

vs.satheesh (1/16/2014)

---

Hi My question is i want move data from production server to testing server.I want take transfer the data in source to destination in all the 50 tables.But one...

+1 🙂