Forum Replies Created

Viewing 15 posts - 1,306 through 1,320 (of 2,838 total)

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (11/7/2011)

    Stefan Krzywicki (11/3/2011)

    Anyone know a good source for on-line SSIS help?

    I'm having a problem with the speed of my main SSIS load package and would love to find...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 7, 2011 at 8:41 am

    #1403992

  • RE: SSIS inserts are very slow

    allmhuran (11/4/2011)

    In the MCTS book on SQL 2005 BI, there is a paragraph on when SSIS can and cannot actually perform a fast load (bulk insert) style operation, even when...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 5, 2011 at 8:10 am

    #1403620

  • RE: SSIS inserts are very slow

    Jeff Moden (11/4/2011)

    Stefan Krzywicki (11/3/2011)

    Each has a GUID primary key.

    Unless you defined otherwise, that's likely your problem. Most people define PK's with the default settings and the default settings...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 5, 2011 at 8:08 am

    #1403619

  • RE: SSIS inserts are very slow

    alexander.suprun (11/4/2011)

    Stefan Krzywicki (11/4/2011)

    alexander.suprun (11/4/2011)

    Stefan Krzywicki (11/3/2011)

    Brandie Tarvin (11/3/2011)

    I forgot to mention something.

    If push comes to shove and you can't use an Execute SQL Task, and absolutely must have a...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 4, 2011 at 5:48 pm

    #1403547

  • RE: SSIS inserts are very slow

    alexander.suprun (11/4/2011)

    Stefan Krzywicki (11/3/2011)

    Brandie Tarvin (11/3/2011)

    I forgot to mention something.

    If push comes to shove and you can't use an Execute SQL Task, and absolutely must have a Data Flow Task...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 4, 2011 at 5:22 pm

    #1403544

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/4/2011)

    SQLRNNR (11/4/2011)

    Oh wait, you meant for query plan operators.

    What is this query plan operator?

    Alien ship attacking Beijing skyscraper?

    Rats, I thought it was Reverse Jenga

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 4, 2011 at 9:49 am

    #1403350

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/4/2011)

    WHOOT! Just got my author's copy of Space Tramps in.

    Space Tramps information:

    Amazon link: http://www.amazon.com/Space-Tramps-Full-Throttle-Tales/dp/0984592741

    ISBN numbers, if you care to order it from your local bookstore (which I highly...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 4, 2011 at 7:37 am

    #1403216

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/3/2011)

    Well, my daughter Kirisa was just inducted into the National Honor Society ths evening!

    Good for her! She must be excited.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 4, 2011 at 7:34 am

    #1403211

  • RE: SSIS inserts are very slow

    Limiting the batch size to the same as the row commit seems to have helped a bit. I should have an environment set up over the weekend to try some...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 4, 2011 at 6:48 am

    #1403181

  • RE: SSIS inserts are very slow

    Evil Kraig F (11/3/2011)

    jcrawf02 (11/3/2011)

    I had a similar question on Andy Leonard's latest Stairway article. I thought SSIS was specifically designed to streamline the ETL process, but it seems staging...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 2:05 pm

    #1402925

  • RE: Are the posted questions getting worse?

    jcrawf02 (11/3/2011)

    Stefan Krzywicki (11/3/2011)

    jcrawf02 (11/3/2011)

    Stefan Krzywicki (11/3/2011)

    Jack Corbett (11/3/2011)

    Stefan Krzywicki (11/3/2011)

    Anyone know a good source for on-line SSIS help?

    I'm having a problem with the speed of my main SSIS load...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 1:35 pm

    #1402913

  • RE: SSIS inserts are very slow

    Greg Edwards-268690 (11/3/2011)

    And if you haven't stumbled upon this already, you may want to have a peek.

    Thanks, I'll give it a look.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 1:32 pm

    #1402908

  • RE: Are the posted questions getting worse?

    jcrawf02 (11/3/2011)

    Stefan Krzywicki (11/3/2011)

    Jack Corbett (11/3/2011)

    Stefan Krzywicki (11/3/2011)

    Anyone know a good source for on-line SSIS help?

    I'm having a problem with the speed of my main SSIS load package and would...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 1:08 pm

    #1402893

  • RE: SSIS inserts are very slow

    jcrawf02 (11/3/2011)

    I had a similar question on Andy Leonard's latest Stairway article. I thought SSIS was specifically designed to streamline the ETL process, but it seems staging tables and updates...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 1:05 pm

    #1402890

  • RE: SSIS inserts are very slow

    Brandie Tarvin (11/3/2011)

    I forgot to mention something.

    If push comes to shove and you can't use an Execute SQL Task, and absolutely must have a Data Flow Task instead, use a...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    November 3, 2011 at 12:27 pm

    #1402864

Viewing 15 posts - 1,306 through 1,320 (of 2,838 total)