Forum Replies Created

Viewing 15 posts - 406 through 420 (of 669 total)

  • RE: How to replace the blank values to NULL for a field in SSIS

    sqlbi (9/20/2010)


    can you provide the solution, basically the incoming field has

    0.0

    25.0

    and i want to replace it with NULL

    ...

  • RE: Delta refresh of an SSAS cube

    Process Default(Full) is always suggested for UDM

  • RE: SSRS 2005

    Mahalingam,

    Please follow the following steps:

    Step 1: Insert a header field

    Step 2: Insert a footer field

    Step 3: Insert all data regions you wish in the body field

    Thus incase of any logical...

  • RE: SSRS 2005

    Please follow here

  • RE: Year To Date as MDX in cube? or just query?

    RonKyle (9/14/2010)


    I have some very complex (at least they seem so to me) time queries in my cubes, and they don't kill performance. It is important, however, to have...

  • RE: SSRS 2005

    mahagold (9/20/2010)


    Hi,

    I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and

    printing invoices.

    I have grouped the report based on Invoice ...

  • RE: SSIS Package Execution

    Good question.:-):-):-)

  • RE: SSIS excel sheet

    da-zero (9/20/2010)


    Allright, it is time to dive into the details.

    How did you set-up your packages? What tasks/components did you use? What connectors did you use? What are the expressions/variables/package configurations...

  • RE: Home page

    Steve Jones - Editor (9/18/2010)


    That looks fine to me. What do you think is wrong?

    Steve,

    The Home page css is apparently distorted...it appears slightly extended towards right on my screen

    The follow...

  • RE: Put logic inside Execute SQL Task or call sproc?

    Ted Pin (9/16/2010)


    I have been using SSIS for years and have never been able to decide whether it's usually better to put SQL logic in an Execute SQL Task or...

  • RE: working with multiple tables in report builder

    masqazi (9/18/2010)


    i have developed a report model with mulitiple table, which are linked with master-child relationship...

    in report builder, when i select one table i cannot get data from another table...even...

  • RE: YTD MDX Question

    WITH MEMBER [MEASURE_NAME] AS

    AGGREGATE

    (

    PERIODSTODATE

    (

    [Date].[Calendar].[Calendar Year],

    [Date].[Calendar].CurrentMember

    ),

    ([Measures].[Sales Amount])

    )

    Note: This Measure will give you a cumulative value of total sales till current...

  • RE: YTD MDX Question

    randy.jaye (9/17/2010)


    I am trying to build a calculated member in a SSAS cube. I am relatively new to this process so I may not be aware of all the...

  • RE: How to use reporting services on a different web server

    GF (9/17/2010)


    I have SQL 2005 Reporting Services Installed on Web Server A and it is running fine.

    I would like to run a report on Web Server B, on a different...

  • RE: delete Files and Folders > 90 days Using SSIS

    anuragingle (9/16/2010)


    got the solution

    just named the folders with the current date and use rmdir command

    Anurag,

    Great job!!!

    But still follow a framework approach while implementing and architeting an enterprise solution

Viewing 15 posts - 406 through 420 (of 669 total)