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

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

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

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

  • RE: The SQLServerCentral Party at PASS

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

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

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

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

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

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

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

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

  • RE: Absolutely (Not?)

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

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

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

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