Forum Replies Created

Viewing 15 posts - 91 through 105 (of 3,666 total)

  • RE: SSIS 2012: Concurrent Package Execution w Different Parameters?

    N.B. (1/12/2016)


    Greetings,

    I've been trying to find an answer to this for a couple of days, but either it doesn't exist (unlikely), or I'm just not phrasing the question correctly (far...



    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 to see SSIS variable value when package fails via sql agent job

    If it works fine in BIDS but not as a SQL Agent job, then it's likely a rights issue or an issue with a parameter being passed at execution time.

    You...



    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: newbie wants to know what a HEAP is ?

    mw112009 (1/11/2016)


    Cool!

    You thought I didn't GOOGLE ha ?

    Take a look at the attached! LOL

    Hint: try Googling: SQL heap

    How good the search results you get are depends a lot on your...



    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: newbie wants to know what a HEAP is ?

    A heap is how much trouble you're in if you mess up your database.

    Seriously now, did you try to Google Heap?

    Here's the first link Google showed me.

    https://msdn.microsoft.com/en-us/library/hh213609%28v=sql.110%29.aspx



    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: Date Conversion

    Eric M Russell (1/11/2016)


    Alvin Ramard (1/11/2016)


    Eric M Russell (1/11/2016)


    rahulsahay123 (1/8/2016)


    I am getting a data feed with date column of type integer.Format is mmddyyyy.

    Values are like : 01092015

    Now...



    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?

    Ed Wagner (1/11/2016)


    Jack Corbett (1/11/2016)


    Ed Wagner (1/11/2016)


    Koen Verbeeck (1/11/2016)


    Ed Wagner (1/11/2016)


    Grumpy DBA (1/11/2016)


    Grant Fritchey (1/11/2016)


    Continuing my role as the harbinger of death, Ziggy Stardust is no more.

    One...



    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?

    J Livingston SQL (1/11/2016)


    GilaMonster (1/11/2016)


    Steve Jones - SSC Editor (1/11/2016)


    Grant Fritchey (1/11/2016)


    Continuing my role as the harbinger of death, Ziggy Stardust is no more.

    One of my favorite songs. Although...



    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: Header and Detail Data

    Orlando Colamatteo (1/11/2016)


    Alvin Ramard (1/11/2016)


    If using SSIS, I think it would be easier to first dump the headers and details into separate files then using a script task to merge...



    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: Header and Detail Data

    If using SSIS, I think it would be easier to first dump the headers and details into separate files then using a script task to merge the two files together....



    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: Header and Detail Data

    I can see a way of doing this in SSIS, if the output is a text file with one or two columns.

    What's I'm visualizing is rows in the data flow...



    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: Date Conversion

    Eric M Russell (1/11/2016)


    rahulsahay123 (1/8/2016)


    I am getting a data feed with date column of type integer.Format is mmddyyyy.

    Values are like : 01092015

    Now i want to convert 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: Date Conversion

    Lynn Pettis (1/8/2016)


    Jason A. Long (1/8/2016)


    rahulsahay123 (1/8/2016)


    I am getting a data feed with date column of type integer.Format is mmddyyyy.

    Values are like : 01092015

    Now i want to...



    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: Date Conversion

    Jason A. Long (1/8/2016)


    rahulsahay123 (1/8/2016)


    I am getting a data feed with date column of type integer.Format is mmddyyyy.

    Values are like : 01092015

    Now i want to convert 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: Date Conversion

    johnwalker10 (1/8/2016)


    SELECT convert(varchar, getdate(), 102)

    How can this work? Reread the OP's post.



    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: Table Creation - Tool

    I'm sure we can all agree that no tool can prevent bad designs.



    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 - 91 through 105 (of 3,666 total)