Forum Replies Created

Viewing 15 posts - 181 through 195 (of 544 total)

  • RE: Why not processing any records further?

    Lynn Pettis (8/17/2012)

    Two questions.

    First, why are you copying the records with a different sequence no (really just curious about the business requirement)

    Second, why does it have to be done in...

    August 17, 2012 at 8:42 am

    #1527117

  • RE: Row_Number() in SSIS?

    Lynn Pettis (8/17/2012)

    Charmer (8/17/2012)

    Lynn Pettis (8/17/2012)

    If you mean that your query is loading a staging table, that isn't what I am talking about. I am talking about copying the...

    August 17, 2012 at 8:39 am

    #1527115

  • RE: Row_Number() in SSIS?

    Lynn Pettis (8/17/2012)

    If you mean that your query is loading a staging table, that isn't what I am talking about. I am talking about copying the data from the...

    August 17, 2012 at 8:21 am

    #1527104

  • RE: Row_Number() in SSIS?

    Lynn Pettis (8/17/2012)

    If you can't clean the data in the source tables prior to using it, stage the data in temporary tables, cleaning the data as you load it. ...

    August 17, 2012 at 7:53 am

    #1527090

  • RE: Why not processing any records further?

    ChrisM@Work (8/17/2012)

    Charmer (8/17/2012)

    ChrisM@Work (8/17/2012)

    Are you inserting new rows into a table or updating existing rows? It's not clear from your description.

    yes i am inserting new rows by taking all the...

    August 17, 2012 at 7:50 am

    #1527084

  • RE: Why not processing any records further?

    ChrisM@Work (8/17/2012)

    Are you inserting new rows into a table or updating existing rows? It's not clear from your description.

    yes i am inserting new rows by taking all the rows which...

    August 17, 2012 at 7:08 am

    #1527064

  • RE: Why not processing any records further?

    ThomasRushton (8/17/2012)

    Are there any locks in evidence on the source or destination tables?

    It might be worth trying to reduce the transaction batch size - the number of updates / inserts...

    August 17, 2012 at 7:06 am

    #1527063

  • RE: Row_Number() in SSIS?

    Lynn Pettis (8/14/2012)

    Charmer (8/14/2012)

    Lynn Pettis (8/14/2012)

    I'd like to see the query, tables and indexes, and the actual execution plan of the query. Never know, there may be some tuning...

    August 17, 2012 at 2:30 am

    #1526950

  • RE: Row_Number() in SSIS?

    Lynn Pettis (8/14/2012)

    I'd like to see the query, tables and indexes, and the actual execution plan of the query. Never know, there may be some tuning that can be...

    August 14, 2012 at 11:08 am

    #1525677

  • RE: Row_Number() in SSIS?

    Matt Miller (#4) (8/14/2012)[/b

    How much of a drag does the ROW_NUMBER() aspect put on query execution? It sounds like you already have a fairly hefty process.

    i am not able...

    August 14, 2012 at 10:58 am

    #1525667

  • RE: Row_Number() in SSIS?

    Phil Parkin (8/14/2012)

    Sounds like you want to do the sort in SSIS rather than T-SQL - bad idea. One way or another, you should make the SQL engine do that...

    August 14, 2012 at 10:48 am

    #1525661

  • RE: Row_Number() in SSIS?

    Lynn Pettis (8/14/2012)

    Charmer (8/14/2012)

    Lynn Pettis (8/14/2012)

    Have you tried tuning your SQL query?

    Yes, Lynn...my SQL query has no other way....this is it...:(

    Not sure what you mean by "has no other way."

    i...

    August 14, 2012 at 10:37 am

    #1525652

  • RE: Row_Number() in SSIS?

    Lynn Pettis (8/14/2012)

    Have you tried tuning your SQL query?

    Yes, Lynn...my SQL query has no other way....this is it...:(

    August 14, 2012 at 10:31 am

    #1525647

  • RE: Row_Number() in SSIS?

    Lynn Pettis (8/14/2012)

    And the question is, what?

    sorry, Lynn...i acciedntly pressed the enter button before completing hte question....i am sorry...:-)

    August 14, 2012 at 10:20 am

    #1525638

  • RE: Getting the Duplicate rows?

    Koen Verbeeck (8/9/2012)

    Charmer (8/8/2012)

    Hi Friends,

    i am doing a project in SSIS 2008, SQL 2008R2...

    In the data flow,

    my source(OLEDB) has some duplicate records where i am removing the duplicate rows...

    August 9, 2012 at 2:43 am

    #1523622

Viewing 15 posts - 181 through 195 (of 544 total)