Forum Replies Created

Viewing 15 posts - 1,006 through 1,020 (of 3,666 total)

  • RE: How to consolidate all error messages to one email from a send email task?

    Don't send the email from the event handler.

    Add an email task that runs at the end of the processing and use what I recommended earlier.



    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?

    Jeff Moden (8/4/2014)


    Alvin Ramard (8/4/2014)


    GilaMonster (8/4/2014)


    If the questions have worn you out, may I suggest a couple of maths limericks?

    http://iwastesomuchtime.com/on/?i=93785

    A dozen, a gross and a score

    plus three time the square...



    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?

    GilaMonster (8/4/2014)


    If the questions have worn you out, may I suggest a couple of maths limericks?

    http://iwastesomuchtime.com/on/?i=93785

    A dozen, a gross and a score

    plus three time the square root of four

    divided by...



    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: How to consolidate all error messages to one email from a send email task?

    Create a variable to hold the text you want as the email body.

    Have the event handler(s) append the error messages to this variable.

    Add an email task at 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: Today's Humor..

    SCARY!!!!!!



    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: Today's Humor..

    Grant Fritchey (7/31/2014)


    Sarah Wagner (7/31/2014)


    I hired in to a software company and sad to say we were one of those vendors. Gladly we are not anymore as I rewrote all...



    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: Today's Humor..

    Luis Cazares (7/30/2014)


    Eirikur Eiriksson (7/30/2014)


    Luis Cazares (7/30/2014)


    Alvin Ramard (7/30/2014)


    WAIT!!!! What kind of database MUST be repaired regularly???? :w00t:

    The one that is shrinked regularly?

    Guess shrinked is the simple mode...



    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: Today's Humor..

    WAIT!!!! What kind of database MUST be repaired regularly???? :w00t:



    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: how do you break out of a foreach loop

    Tim Mitchell (7/29/2014)


    A foreach loop in SSIS is, by definition, an iteration of n items, in which n is defined at the beginning of the loop. So you can't...



    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: Returning multiple values from a single value

    vito.mangogna (7/29/2014)


    I'm trying to write a query that will return three related values from a single value.

    My input data in it's simplest form is this:

    select employeeID, TotalHours from TimeTicket

    I...



    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: Name table

    If you're looking for a list of names, Google: "nicknames and full names" and you'll find a few.

    What you're trying to do is a simple use of a lookup table....



    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: How to efficiently import data in .rpt format into SQL 2008

    Jeff Moden (7/24/2014)


    Alvin Ramard (7/24/2014)


    Jeff Moden (7/23/2014)


    halifaxdal (7/23/2014)


    Alvin Ramard (7/23/2014)


    Reading about this after all the discussion, I'm starting to think it would have been a lot faster to try 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: How to efficiently import data in .rpt format into SQL 2008

    Jeff Moden (7/23/2014)


    halifaxdal (7/23/2014)


    Alvin Ramard (7/23/2014)


    Reading about this after all the discussion, I'm starting to think it would have been a lot faster to try the import with VB or...



    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: How to efficiently import data in .rpt format into SQL 2008

    It looks like a normal task, but you task was made more complicate by the fact that the file is not properly formatted for a "data exchange" file. Sometimes,...



    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: How to efficiently import data in .rpt format into SQL 2008

    Reading about this after all the discussion, I'm starting to think it would have been a lot faster to try the import with VB or C#, or at least fix...



    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,006 through 1,020 (of 3,666 total)