Forum Replies Created

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

  • RE: Handling delimted rows

    Import the records from the file as if each record only contains 1 very long text-field, delete the extra |, then run it through your "normal code".

    You could even make...

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: Auto submit in SSRS report

    AFAIK you can not change that behaviour, unless you build your own UI on top of reportviewer.

    When you think it over it even makes sense it works this way: when...

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: email invoice pdf to customer when invoice inserted

    I'm not sure if you should do this entirely in SSRS, but if you choose so:

    1) build a report that is the invoice (check whether it exports correctly to pdf)

    2)...

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: show data as columns

    you should use a matrix instead of a table in your report.

    put topic in Columns, add a row in the Data part, than put score1 and score2 in the 2...

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: How to format Strings in cells

    This can't be done in SSRS 2005, but should be possible in 2008 or R2 (i'm not quite sure which one)

    As I have no 2008 or R2 available I can...

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: ERROR TRANSFERING DATA FROM SQL DATABASE TO EXCEL FILE

    I did a little test in SSIS 2005 (don't have a SQL 2008 around to test that as well), and as I expected it fails if you map a nvarchar...

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: Sending Mail In SSIS Using Script Task- Simpler and Flexible Approach

    Brett Flippin (5/6/2009)


    It sounds like from that example that you could do that with For or Foreach Loop container to loop through your emails and do the appropriate operations instead...

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: Sending Mail In SSIS Using Script Task- Simpler and Flexible Approach

    As stated this might have been an interesting article when it was complete.

    However: apart from the missing images I read no arguments in his article to come to the conclusion...

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: Side by Side

    I totally agree with Robert.

    BOL 2008 doesn't mention SQL Server 7.0 since mainstream support for 7.0 ended in 2005. So the BOL 2008 doesn't mention it as "side by side...

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: MCITP DBA numbers - so few

    As for prep material for the 2008 exams: as said in several posts in these forums you can use the 2005 prep materials, if you make sure to do proper...

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: Custom rollups across multiple dimensions

    I looked at some of my code, and I think you should declare the calculated measure first, and the scope after that. See the source I found (that is working...

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: Can not do the average line in SSRS2005

    The way you describe your problem sure makes it difficult to tackle ...

    Here's what I think you should do:

    Use an average on the Col2 of the dataset, instead of an...

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: SSIS - there's more than one way to skin a cat or Whats the best way to load a csv file?

    Shaun McGuile (1/15/2009)

    'What specific objects from the tool box are the 'right' ones' to use to do the job?'

    That's also how I read it, and it made me think about...

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: Database Snapshots

    Lempster (1/15/2009)

    I am probably being pedantic, but as long as no changes have been made to a database, it can be taken offline/brought online regardless of whether a snapshot exists...

    Peter Rijs
    BI Consultant, The Netherlands

  • RE: Database Snapshots

    liam.north (1/15/2009)


    I think the original question is slightly misleading; only files can be taken offline individually - there is no ALTER DATABASE statement to take a filegroup offline.

    I don't think...

    Peter Rijs
    BI Consultant, The Netherlands

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