Forum Replies Created

Viewing 15 posts - 1,996 through 2,010 (of 3,666 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/25/2010)


    Alvin Ramard (8/25/2010)


    OP was complaining about PK violation while uploading text file using SSIS.

    Someone replied with:

    How do you get a PK violation?

    Are you inserting the PK values yourself?...



    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?

    OP was complaining about PK violation while uploading text file using SSIS.

    Someone replied with:

    How do you get a PK violation?

    Are you inserting the PK values yourself?

    Please remind me,...



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


    Shhh, all this talk about NZ might get my wife talking about making me take her on a plane for 18 hours. Yikes! :w00t:

    Send her 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: For each loop container not working as expected (only reads the first file)

    I don't see anything wrong.

    Try this:

    1 - Add a new For Each Loop to the package and configure it to read the same files. (DO NOT use copy...



    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?

    Ross McMicken (8/25/2010)


    Jack Corbett (8/23/2010)


    Steve Jones - Editor (8/23/2010)


    I saw that from Brent. Paul is garnering lots of respect from the other gurus.

    We need to get Paul out here 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: Are the posted questions getting worse?

    Question for the User Group leaders on here:

    Have any of you tried to export the list of members from the new and improved (and possibly sucks more than before) UserGroupSupportServices...



    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: For each loop container not working as expected (only reads the first file)

    Raunak Jhawar (8/25/2010)


    Check the Files text area..(have provided any delimiter or any specific extension)

    Chek the status of Traverse Sub Folders checkbox

    Traverse sub folders has no affect on the root folder.



    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: ssis and ssrs interview questions

    Greg Edwards-268690 (8/25/2010)


    Alvin Ramard (8/24/2010)


    GilaMonster (8/24/2010)


    Alvin Ramard (8/24/2010)


    Don't you use a triangular join to join 3 tables? 😛

    That means you'll need a CROSS JOIN for 4 tables. :hehe:

    Yep.

    I'm clueless...



    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: ssis and ssrs interview questions

    GilaMonster (8/24/2010)


    It'll have to be a HASH join, it's advertised as the one that handles large numbers.

    I guess that 6 tables would be one hex of a join. 😎



    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: For each loop container not working as expected (only reads the first file)

    I'm afraid that there's not much more I can do without seeing the what the package/loop looks like.



    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: For each loop container not working as expected (only reads the first file)

    I think I see your problem. It looks like you do not have a proper "search string" for your ForEach container.

    Open up the ForEach Editor and look 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: ssis and ssrs interview questions

    GilaMonster (8/24/2010)


    Alvin Ramard (8/24/2010)


    Don't you use a triangular join to join 3 tables? 😛

    That means you'll need a CROSS JOIN for 4 tables. :hehe:

    Yep.

    I'm clueless about what kind of...



    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: For each loop container not working as expected (only reads the first file)

    anavill (8/24/2010)


    Sorry it was a typo , I wanted to say Overwrite option NOT checked", so it is APPENDÏNG data to the file.

    I already tried adding in the VB code...



    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: For each loop container not working as expected (only reads the first file)

    J.D. Gonzalez (8/24/2010)


    Alvin Ramard (8/24/2010)


    Then you might try to add a VB (or C#) Script Task a the first task to execute in the For Each container. Pass 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: For each loop container not working as expected (only reads the first file)

    First, double check that both files match the wildcard that you entered in the "Files:" box.

    Then you might try to add a VB (or C#) Script Task a the first...



    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,996 through 2,010 (of 3,666 total)