select datename(month, getdate()) will get you the name of the month. If you need to use case it could look like

case

when datepart(month, getdate()) = '01' then 'January'

when datepart(month, getdate())...

I have spent more time than I care for in the SMS database trying to retain where MS is storing pertinent data and it is extremely confusing to say the...

I'm assuming you are using a Execute SQL task or a transform data task and if so, I believe you still have to have a linked server in order to...

One question I would ask would be what jobs are running throughout the day that could potentially cause memory munching? I have seen Mail tasks eat memory quite efficiently and...

I realize that this is a migration related document but, if you can understand what it takes to migrate, you should be better off in understanding how they compare. Hope...

Do you mean case?

David

I don't know if you guys are intentionally teasing this poor gentlemen but, he wants to go FROM SQL SERVER TO ORACLE.

Bad enough that he is going the wrong...

Phill,

It should not be SQL having a problem running it from xp_cmdshell. Anything that you can run from a cmd prompt, it can run from through xp_cmdshell.

A couple more...

That error is usually associated with an invalid or an inaccessible path. Is it possible that some other backup application has the drive space access limited during these times? Just...

You can actually wrap the whole path in double quotes and that will take care of the problem.

ex: "C:\Program Files\Testing\Testing One\One.exe"

Ultimately you should be able to take the...

Alright Andy - I'm reading your articles on DMO and am now thoroughly convicted to do SOME work that way.

Thanks for the laugh Steve!

David

I didn't have any issues in Beta either.

I did read that you can't install using WTS right now so I am holding off until I can research that out....

What you mean Oracle doesn't provide easy to use tools to migrate from SQL Server to their DBMS? I'm surprised. Seriously. I figured it would be a two way street....

You can use isnull(ColName, '') BOL covers this with a great deal more detail. Hope this helps.

David

Agree with Steve completely. I have been functioning as a full time DBA (part time doing other tasks prior to this) for less than a year and I believe that...