When you login to the VM, find the 'My Computer' or 'Computer' icon. Rt-Click that, go to manage. In the window that comes up, go to "Services and...

blasto_max (1/16/2014)

---

I don't have any knowledge of administration. Can you point me to some guide which could help me to perform the troubleshooting which you mentioned ?

Eg. how do...

Okay, definately running under the agent then, if...

My pleasure, glad I could help.

blasto_max (1/16/2014)

---

I wonder why someone would provide this in a text file (or even in a database table - i've seen this). Is there a better way to do the...

Is the deployment failing when you deploy the package to the MSDB server and manually execute via Rt-Click, or when you schedule it via the Agent?

If it's the Agent, make...

Whut? Why? ... but alright.

I need to loop through all of them execute the...

You're using DTExecUI (User Interface), which is why.

What you want is plain old DTExec:

http://technet.microsoft.com/en-us/library/ms162810(v=sql.105).aspx

By the by, why not just use a job and the SSIS step in SQL Agent?

TheSQLGuru (1/16/2014)

---

Why do you want a script to do this? Temp objects are automatically "managed" by the engine. Just close the connection and you don't have to worry...

JP10 (1/16/2014)

---

Hello,

Curious if I have the code below as an example and I execute this code does sql execute from top to bottom? And does the Update run and...

I'm not overly familiar with enlight, but your approach seems reasonable. The big deal with that is the scientific float items (1.03E-12) which may/may not fit into the target....

I'm glad y'all have environments with space that let you validate your backups. Round here, I'm on the 'pray it worked' method, because I have no place to put...

It's wierd, but when I saw the title to this article I had thought this would be chasing a different concept. One where we SHOULDN'T be craftspeople, because right...

Please note, that's remote execution of...

Bad_Karma (1/10/2014)

---

Thanks for the heads-up, however what I was considering was leaving the default database isolation level as-is, and instead just declaring the isolation level on all of my SSRS...