Forum Replies Created

Viewing 15 posts - 1,381 through 1,395 (of 3,666 total)

  • RE: SSIS Email Genaration with Error message in the Body

    I use an On Error event handler at the package level to append the System::ErrorDescription variable to my own variable for any error that occurs. I then include the...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: real time in ssis etl developer

    da-zero (10/22/2010)


    Alvin Ramard (10/22/2010)


    krishna.msbi2008 (10/22/2010)


    hiiii frds..

    After deploy the package in filesystem.

    how the client can extract the package

    What do you mean by: "extract the package"?

    I can't help but wonder what the...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: real time in ssis etl developer

    krishna.msbi2008 (10/22/2010)


    hiiii frds..

    After deploy the package in filesystem.

    how the client can extract the package

    What do you mean by: "extract the package"?

    I can't help but wonder what the client that hired...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    LutzM (10/22/2010)


    ALZDBA (10/22/2010)


    Jeff Moden (10/21/2010)


    ALZDBA (10/20/2010)


    Dito.

    And it only serves a single purpose. i.e. strict hierarchy.

    Ever tried building a family tree ?

    Thanks for the input, Johan. Heh... from what I've...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    GSquared (10/22/2010)


    You might run into problems with the maximum data size on hierarchy IDs if you're doing a REALLY large family tree, but real-world limitations on data availability probably make...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    ALZDBA (10/22/2010)


    To get you started .... assume every documented pigeon has one male and one female pigeon for parents.

    Attached a little brainstorm to start with an experiment on the hierarchy...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/21/2010)


    Q: Explain how to determine if a table has a primary key?

    Lock the database, if the table can get back in, it has a key.

    That's not 100% correct....



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Tom.Thomson (10/19/2010)


    I found this response http://www.sqlservercentral.com/Forums/FindPost1007296.aspx to a typical Celko post quite amusing.

    Your link doesn't work. There's a single quote at the end of the url. I removed it from...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    jcrawf02 (10/19/2010)


    I can see how you'd miss that, as it's in the third sentence, and that's WAY too much to read....:w00t::-P:-D

    My input buffer filled up before I hit the end...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (10/19/2010)


    Stefan Krzywicki (10/19/2010)


    Greg Edwards-268690 (10/19/2010)


    Alvin Ramard (10/19/2010)


    Stefan Krzywicki (10/19/2010)


    Alvin Ramard (10/19/2010)


    Steve, do we have an award for this one?

    http://www.sqlservercentral.com/Forums/Topic1007106-392-1.aspx

    Should give him a Lincoln award for preserving the Union.

    ......



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    jcrawf02 (10/19/2010)


    GSquared (10/19/2010)


    Steve Jones - SSC Editor (10/19/2010)


    WayneS (10/18/2010)


    ... we need several hundred years of records to know this, and we barely have one hundred. I also believe that this...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: FTP task when file is not found. A better way to handle....

    msmall 95832 (10/19/2010)


    .... I guess when I build the file collection I should check first if the files exists before adding the filename to the collection variable. However...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: I need to create ssis package with the variables

    There's a checkbox in the flat file destination that determines whether the data is overwritten or not.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (10/19/2010)


    Alvin Ramard (10/19/2010)


    Steve, do we have an award for this one?

    http://www.sqlservercentral.com/Forums/Topic1007106-392-1.aspx

    Should give him a Lincoln award for preserving the Union.

    ... and people say MY jokes are bad? ...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • RE: Are the posted questions getting worse?

    Greg Edwards-268690 (10/19/2010)


    Alvin Ramard (10/19/2010)


    Steve, do we have an award for this one?

    http://www.sqlservercentral.com/Forums/Topic1007106-392-1.aspx

    Some kind of Novel award?

    I almost feel like copying the select statement and see how many pages it...



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 15 posts - 1,381 through 1,395 (of 3,666 total)