Forum Replies Created

Viewing 15 posts - 9,901 through 9,915 (of 19,560 total)

  • RE: SSIS FTP Task

    So you establish an ftp connection to the directory first. You do not try to change directory whatsoever, and you get an error message upon attempting to transfer files...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Today's Random Word!

    crookj (6/2/2011)


    Bovine

    Joe

    Stole mine

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Execute Multiple sql statements thru SSIS..

    You could accomplish this with several dataflows outputing to temptables or a single temptable and then perform one last dataflow where it unions those tables and outputs to a single...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: SSIS FTP Task

    K then, my question is still valid. Are you establishing a connection to the root or to that directory first? Then are you trying to change directories to...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: SSIS FTP Task

    gauravin2007 (6/2/2011)


    Actually I am trying to get the reports from the UNIX server to my local desktop. and im getting an error that the file or folder does not exist.

    Using...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    LutzM (6/2/2011)


    SQLRNNR (6/2/2011)


    LutzM (6/2/2011)


    To quote from a thread I've been involved:

    Also, I will start to participate on the site more often. It has always been useful and seems to be...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    LutzM (6/2/2011)


    To quote from a thread I've been involved:

    Also, I will start to participate on the site more often. It has always been useful and seems to be very helpful...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Today's Random Word!

    equine

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Ghost Records

    GilaMonster (6/2/2011)


    SQLRNNR (6/2/2011)


    GilaMonster (6/2/2011)


    cfradenburg (6/2/2011)


    As to why something goes through and cleans up the ghost records instead of just allowing the space get reused, that way the data doesn't remain...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Ghost Records

    GilaMonster (6/2/2011)


    cfradenburg (6/2/2011)


    As to why something goes through and cleans up the ghost records instead of just allowing the space get reused, that way the data doesn't remain on disk...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Today's Random Word!

    crookj (6/2/2011)


    WOTD - curiosity

    Joe

    killed

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: SSIS FTP Task

    Are you ftp'ing directly to that directory and then attempting to change to it again after the connection is established?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    SQLRNNR (6/1/2011)


    jcrawf02 (6/1/2011)


    Ok, worst joke I never got:

    "What do you get when you cross a mountain climber and a mosquito?

    Nothing, you can't cross a scalar and a vector!"

    Wut? How is...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    jcrawf02 (6/1/2011)


    Ok, worst joke I never got:

    "What do you get when you cross a mountain climber and a mosquito?

    Nothing, you can't cross a scalar and a vector!"

    Wut? How is a...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (6/1/2011)


    GilaMonster (6/1/2011)


    DBCC RunLikeHell

    DBCC MyEyesMyEyesIveGoneBlind

    SOM

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 15 posts - 9,901 through 9,915 (of 19,560 total)