Forum Replies Created

Viewing 15 posts - 2,656 through 2,670 (of 9,725 total)

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 11, 2015 at 6:06 am

    #1796930

  • RE: Trace Flag 4299?

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

    Thanks, Gail. I appreciate the insight.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 11, 2015 at 5:43 am

    #1796923

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 11, 2015 at 4:49 am

    #1796905

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 1, 2015 at 7:20 am

    #1794974

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 1, 2015 at 5:29 am

    #1794942

  • 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....

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 1, 2015 at 5:18 am

    #1794936

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 30, 2015 at 7:23 am

    #1794667

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 30, 2015 at 6:07 am

    #1794629

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 30, 2015 at 5:13 am

    #1794612

  • 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?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2015 at 10:33 am

    #1794399

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2015 at 10:26 am

    #1794397

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2015 at 9:31 am

    #1794352

  • 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...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2015 at 9:12 am

    #1794334

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

    Hrm... I'm not getting any response in the command prompt window. I'm just seeing the echo of my commands, nothing else.

    Any more thoughts?

    EDITED to add .bat file code.

    rem Automatically abort...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2015 at 9:07 am

    #1794330

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

    jasona.work (4/29/2015)

    As a way to temporarily troubleshoot the batch file, without jumping through dozens of hoops, try adding pauses as strategic points (or between each command.)

    Yes, you'll need to hit...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    April 29, 2015 at 9:03 am

    #1794324

Viewing 15 posts - 2,656 through 2,670 (of 9,725 total)