Forum Replies Created

Viewing 15 posts - 91 through 105 (of 312 total)

  • RE: Creating Dynamic Outputs in SSIS to an SQL Database

    sorry it's taken a few days to get back to you.

    I suspect it not actually anything to do with the result set. Double check your SQL statement is correct.

    When...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • RE: SSIS Data Tuning Question

    da-zero (11/16/2010)


    Can every column contain it's maximum size? There's no chance in shrinking the size?

    If not, just don't use blocking components 🙂

    highly unlikely that they will - it's a poorly...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • RE: Reporting Services Disaster Recovery

    Hi Simon.

    the RSExecRole wasn't something I ever really considered - most likley because I never encountered an issue with security and accessing the report server db.

    As you mention it, my...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • RE: SSIS Data Tuning Question

    damn it. I suspected as much.

    The 'largest values' row size I have to deal with is a horendous 4276 bytes! the actual data contained in the fields is probably...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • RE: Creating Dynamic Outputs in SSIS to an SQL Database

    two things to double check first.

    1 - when mapping the parameter User::TxType variable. make sure you set the Parameter name to 0 (zero) (by default it'll be something like...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • RE: SharePoint or Cognos - your thoughts

    OK thanks for your input. It's all useful stuff.

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • RE: SharePoint or Cognos - your thoughts

    we had a demo actually from one of our support suppliers and they did make a comment that there consultancy experience has seen SSAS cubes perform better than Cognos cubes....

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • RE: Creating Dynamic Outputs in SSIS to an SQL Database

    mishaluba (11/10/2010)


    Love the detailed instructions. Worked for me "out of the box". Thank you!

    Thats what I like to hear 🙂

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • RE: SharePoint or Cognos - your thoughts

    thanks guys. All interesting comments to read.

    Should we move to a MS solution then it's definately going to be at least SQL 2008. I am pushing...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • RE: Creating Dynamic Outputs in SSIS to an SQL Database

    Here is a PDF copy of the article with images for those that can't see them. ( I can only guess it's because you can't access the flickr server...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • RE: Creating Dynamic Outputs in SSIS to an SQL Database

    images are hosted on flickr - but they should be fine.

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • RE: Creating Dynamic Outputs in SSIS to an SQL Database

    Bertil Forsberg (11/10/2010)


    Hi Dave!

    A nice and clean solution, quite interesting to follow.

    My only objection right now is the phrase 'FEL' in your namings, in swedish that

    means 'WRONG'! 🙂

    Thanks,

    BF

    Also I guess...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • RE: Creating Dynamic Outputs in SSIS to an SQL Database

    Bertil Forsberg: I've learnt something new today! every day is a school day. 🙂

    fszendzielarz: Partitioning for me was not an option as we are only using SQL Server...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • RE: SharePoint or Cognos - your thoughts

    ha ha - it actually might be! Things don't move that fast where I am.

    I would certainly be very interest to hear your views on both. I'm quite...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

  • RE: can't see where to put in web service task input parameters -- is it a bug?

    Hi Karen

    I'm a real newbie when it comes to web services, so forgive me if I ask any stupid questions.

    Is possible you can provide me with an example of how...

    _____________________________________________________________________________MCITP: Business Intelligence Developer (2005)

Viewing 15 posts - 91 through 105 (of 312 total)