Forum Replies Created

Viewing 15 posts - 31 through 45 (of 149 total)

  • RE: dtexec error

    SQL-Learner - Tuesday, March 7, 2017 1:05 PM

    C:\Users>dtexec /f "C:\Users\Documents\Visual Studio 2015\Projects\SSISPackage\Package.dtsx" /Set "\Package.Variables[User::WorkingDirectory].Properties[Value]";"C:\\AzureDirectory\\Scripts\\" /Set "\Package.Variables[User::SUserID].Properties[Value]";"xxx@gmail.com"

    Verify that the package/job is running as...

    Wes
    (A solid design is always preferable to a creative workaround)

  • RE: Weird SSRS issue - column not displaying data

    First place to start, can you confirm that you set a value in the tablix cells?  A screenshot of the tablix in design mode would be helpful.  Make sure you...

    Wes
    (A solid design is always preferable to a creative workaround)

  • RE: Joining INSERTED and UPDATED tables when PK column changes

    Just for grins I wanted to test the Row Numbering of Inserted and Deleted.
    Testing with 1 Million rows, the records were aligned for every row. 
    I feel comfortable...

    Wes
    (A solid design is always preferable to a creative workaround)

  • RE: Joining INSERTED and UPDATED tables when PK column changes

    ScottPletcher - Thursday, February 16, 2017 4:48 PM

    You could add a unique identity column without touching the existing primary key, and that...

    Wes
    (A solid design is always preferable to a creative workaround)

  • RE: Failed to lock variable

    Phil Parkin - Thursday, February 16, 2017 2:16 PM

    Note that having mega packages which do everything is generally regarded as a bad...

    Wes
    (A solid design is always preferable to a creative workaround)

  • RE: Joining INSERTED and UPDATED tables when PK column changes

    Xedni - Thursday, February 16, 2017 12:27 PM

    So I buy the argument that rows are added to inserted/deleted in sequence, but...

    Wes
    (A solid design is always preferable to a creative workaround)

  • RE: Joining INSERTED and UPDATED tables when PK column changes

    Disclaimers:
    1. a redesign of your PKs would be a much better choice.
    2. This approach makes a big assumption and may not work consistently in larger volumes, but it was...

    Wes
    (A solid design is always preferable to a creative workaround)

  • RE: Query never completes with CXPACKET waits

    Isabelle2378 - Wednesday, February 15, 2017 3:59 PM

    The query is coming from an application so I have no control over how it is...

    Wes
    (A solid design is always preferable to a creative workaround)

  • RE: Query never completes with CXPACKET waits

    First, I don't recall seeing how many processors your 2008R2 server has.  If it only has 3GB, any chance it only has a single core as well?  When MAXDOP=0,...

    Wes
    (A solid design is always preferable to a creative workaround)

  • RE: How can i create only 1 Column header per group in SSRS 2008 report

    chris.asaipillai-624309 - Tuesday, February 14, 2017 9:48 AM

    So in actual fact, it should like this

    IBOS Broker Code
                                            LONCGJ8
                                            LONCOMJ8
                                            LONEXJJ8

    The edit mode...

    Wes
    (A solid design is always preferable to a creative workaround)

  • RE: How can i create only 1 Column header per group in SSRS 2008 report

    chris.asaipillai-624309 - Tuesday, February 14, 2017 9:48 AM

    So in actual fact, it should like this

    IBOS Broker Code
                                            LONCGJ8
                                            LONCOMJ8
                                            LONEXJJ8

    Your text is...

    Wes
    (A solid design is always preferable to a creative workaround)

  • RE: How can i create only 1 Column header per group in SSRS 2008 report

    We'll need to see the row and column handles to determine groupings.  Can you set focus on one of the cells and grab a new screenshot?

    Wes
    (A solid design is always preferable to a creative workaround)

  • RE: How can i create only 1 Column header per group in SSRS 2008 report

    Can you post a screenshot of the tablix in design view?

    Another thing you can try is setting Hide Duplicates = True for your IBOS Broker Code field.

    Wes
    (A solid design is always preferable to a creative workaround)

  • RE: Remove partitioning

    Indianrock - Tuesday, February 14, 2017 9:30 AM

    ...but I would definitely like to test disabling the index and then verify that none...

    Wes
    (A solid design is always preferable to a creative workaround)

  • RE: How can i create only 1 Column header per group in SSRS 2008 report

    When you add the new group, check the box to Include the Group Header.  Then delete the new column that was added by the group.  In the Group Header, put...

    Wes
    (A solid design is always preferable to a creative workaround)

Viewing 15 posts - 31 through 45 (of 149 total)