Forum Replies Created

Viewing 15 posts - 541 through 555 (of 1,221 total)

  • RE: connect to Sftp using putty ssis

    I use the following batch file, which uses a command file:

    f:

    date /t

    time /t

    F:\FileDownloads\psftp.exe -pw [mypassword] -b F:\FileDownloads\get.script [mylogin] -bc

    The file get.script has the following:

    mget *.txt

    bye

    Don't include the brackets in the...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: connect to Sftp using putty ssis

    Todd Engen (11/14/2008)


    lduvall (11/14/2008)


    Can someone explain specifically how to create the proxy account so that the fingerprint is stored? I'm going to be running this from SQL Server Agent scheduled...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: connect to Sftp using putty ssis

    You're not creating a proxy account per se, you're just tricking the system account (that scheduled jobs run under) into saving the fingerprint.

    First, create a file called Y.DAT consisting of...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Twitter Your Issues

    skjoldtc (11/13/2008)


    ... I don't want nor need 24/7 connectivity. At work when something fails, yes, but that's the exception.

    Perfectly stated! I don't instant message, I don't text message. ...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The SQLServerCentral Party at PASS

    Woohoo! Very much looking forward to the party and meeting lots of regulars here! :hehe:

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Twitter Your Issues

    Interesting concept. I've always liked the idea of servers telling you when they're developing problems, at least when they're not too sick to be unable to tell you, and...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The Security of You

    mike brockington (11/10/2008)


    ... These will then be published on the Internet, allowing anyone to make their own latex copies, or whatever. Other studies have shown that a simple photo-copy is...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Happy Halloween 2008!

    Congrats, Jerry! My dad is a Christmas baby and my parents were married on the 4th of July, but being a Halloween baby would be very cool! (if you...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Happy Halloween 2008!

    A friend of mine in Phoenix held the best Halloween costume parties, I miss them sorely now that I live in New Mexico. One year, at a different house,...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Absolutely (Not?)

    David Reed (10/29/2008)


    Wayne West (10/29/2008)


    I rather liked the Slashdot comments about Azure Screens of Death. :hehe:

    I'm still sad that they removed the red ones from Longhorn. Red feels more like...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    David, I'm working on a blog post about importing data and have this little code fragment that you might find useful (I love playing with system tables):

    select name + '...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

    Huh, somehow I never noticed that in the documentation about Len() ignoring trailing spaces. Then again, chances are that I never opened BOL for Len() and just pulled it...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Absolutely (Not?)

    I rather liked the Slashdot comments about Azure Screens of Death. :hehe:

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Updating Aging Databases

    GilaMonster (10/28/2008)


    Wayne West (10/28/2008)


    ...The growth numbers would also be interesting to know: will we have more than a million registered users by the end of the year?

    Gonna need a real...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Updating Aging Databases

    I have one 2005 server (for two users!), everything else is 2000. I want to upgrade to 2005 for one reason: memory. I have multiple instances running a...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

Viewing 15 posts - 541 through 555 (of 1,221 total)