Forum Replies Created

Viewing 15 posts - 2,641 through 2,655 (of 9,715 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (5/14/2015)


    Question for the people here...

    Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I...

  • RE: Here are some SQL Server Interview Questions

    pietlinden (5/14/2015)


    Best milkshakes ever. I don't like that boss very much.

    And we're OFF TO THE RACES! Thank you. I did get a chuckle out of that.

  • RE: You know you're having a slow day when...

    yb751 (5/1/2015)


    So I'm browsing the forums and seeing the usual comments like "please provide code and sample data". I'm sitting there and thinking this isn't that hard. I...

  • RE: Trace Flag 4299?

    It could be just set by default in their workplace (part of their install).

    Thanks, Gail. I appreciate the insight.

  • RE: Are the posted questions getting worse?

    SQLRNNR (5/8/2015)


    Lynn Pettis (5/8/2015)


    Geez, now someone doesn't even understand that the code they are running generates and runs dynamic SQL.

    What is dynamic sql?

    Doesn't it involve fireworks and music?

    ISTR there was...

  • RE: Uninstalling SQL 2012

    Perry Whittle (5/1/2015)


    Brandie Tarvin (4/30/2015)


    WHEE! I just got my new servers and am ready to install SQL 2012 when I discovered that one of these servers already has it installed...

  • RE: Uninstalling SQL 2012

    EMarkM (5/1/2015)


    Eirikur Eiriksson (5/1/2015)You could use System Restore to the earliest point available, patch the OS and then install the SQL Server.

    😎

    That's a pretty good idea!

    Otherwise, it'll be just the...

  • RE: Uninstalling SQL 2012

    The problem is that I can't nuke the OS. Corporate has to build servers (we're not allowed) and we had to pull teeth in order to get our new servers....

  • RE: Running WinSCP in SSIS Task / .bat file

    And now it is working.

    Everyone has been incredibly helpful. Thank you. Here's the file Powershell script that I'm using.

    $erroractionpreference = "Stop"

    # Load WinSCP .NET assembly

    [Reflection.Assembly]::LoadFrom("C:\Program Files (x86)\WinScp\WinSCPnet.dll")

    # Setup session...

  • RE: Running WinSCP in SSIS Task / .bat file

    jasona.work (4/30/2015)


    Brandie, I think your batch file is almost there, just a couple more tweaks and it should go.

    That being said, I'm 90% sure that DOS doesn't like single quotes...

  • RE: Running WinSCP in SSIS Task / .bat file

    Ed Wagner (4/29/2015)


    Brandie, a word of encouragement if I may. Your batch file is creating your WinSCP script file. You then invoke it by calling the WinSCP executable...

  • RE: Running WinSCP in SSIS Task / .bat file

    GAH. Now I get nothing at all in the log file. The only upside was I could see the issues in the command prompt.

    SIGH. Why can't this be easy?

  • RE: Running WinSCP in SSIS Task / .bat file

    jasona.work (4/29/2015)


    Brandie,

    You're going to laugh at this one...

    Is going to simply echo your commands into your txt file...

    It should still write (or try to, at least) the output of the...

  • RE: Running WinSCP in SSIS Task / .bat file

    David Burrows (4/29/2015)


    I run WinSCP via Powershell script

    Ooops! you're running is SSIS, ignore me :blush:

    David, my issues are with WinSCP period. So any advice you can give me on...

  • RE: Running WinSCP in SSIS Task / .bat file

    Ed Wagner (4/29/2015)


    Brandie Tarvin (4/29/2015)


    You know how when you run a .bat file that uses command line stuff, a prompt opens up and processes the code?

    That part is what I'm...

Viewing 15 posts - 2,641 through 2,655 (of 9,715 total)