Forum Replies Created

Viewing 15 posts - 1,831 through 1,845 (of 3,666 total)

  • RE: saving a date to a varchar field as YYYY-MM-DD

    skcadavre (9/9/2010)


    Alvin Ramard (9/9/2010)


    3 of us posted an answer, but I think I'm the only one with the right format. (120 vs 102)

    True. I didn't really look at the format...



    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: saving a date to a varchar field as YYYY-MM-DD

    3 of us posted an answer, but I think I'm the only one with the right format. (120 vs 102)



    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: saving a date to a varchar field as YYYY-MM-DD

    dave-dj (9/9/2010)


    Hi,

    this sounds simple, but I can't seem to get it to work.!

    I have a store procedure that basically generates a date, that needs to be put into a database...



    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: Add number of days to date variable

    Have you looked at DateAdd?



    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: Need advice on designing DTS..

    As you probably already know, DTS was not made for looping.

    I would probably do the looping inside an ActiveX script and have the script call the next step, passing 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: Are the posted questions getting worse?

    Jack Corbett (9/9/2010)


    Alvin Ramard (9/9/2010)


    Alvin Ramard (9/9/2010)


    GilaMonster (9/9/2010)


    ALZDBA (9/9/2010)


    Or maybe even contact Allen White via LinkedIn.

    Or just think about him really hard and he'll appear. 😀

    Looks like someone was really...



    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?

    Steve Jones - Editor (9/9/2010)


    WayneS (9/8/2010)


    Hey Steve - what's the new avatar?

    My wife got me a new hat this past weekend. I was wearing it when I went to take...



    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?

    ARGH!! Hit by the quoting the wrong post, again!

    Move on, move on. There's nothing to see here. 😎



    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?

    Brandie Tarvin (9/9/2010)


    GilaMonster (9/9/2010)


    ALZDBA (9/9/2010)


    Or maybe even contact Allen White via LinkedIn.

    Or just think about him really hard and he'll appear. 😀

    Hey! This group is psychotic!

    ... um, psychic. I meant...



    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 (9/9/2010)


    ALZDBA (9/9/2010)


    Or maybe even contact Allen White via LinkedIn.

    Or just think about him really hard and he'll appear. 😀

    Looks like someone was really linked in. 😛



    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: dynamically decide which SSIS package to use.

    I would use a script task in the control flow.

    The .NET code should read the first line; count the number of delimiters; set variable equal to the count. (How?...



    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: dynamically decide which SSIS package to use.

    slakhanp (9/9/2010)


    Hi,

    The Simple logic for this Package is that While reading data from flat file use row count transform.After Reading data from flat file using data flow task.Use expression...



    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: Password Protect Excel Destination File

    2 options come to mind.

    1 - Use a .NET (VB or C#) script to password the file via Excel.

    2 - Password the file via a file compression program...



    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: Urgent: Need Help to change server connection of SSIS packages

    WayneS (9/8/2010)


    ... yep, it's labor intensive for 100 packages ...

    I agree, but it's not that bad if you think about it before you start. There's lots of benefits...



    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 (9/8/2010)


    Alvin Ramard (9/8/2010)


    Jeff Moden (9/8/2010)


    Withdrawn... it was just a little too racy...

    Too much bull? 😛

    Yep... sometimes I forget that even though this is a water cooler forum,...



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