Hacking the DTSX (SSIS XML file) to Change Defaults

  • Comments posted to this topic are about the item Hacking the DTSX (SSIS XML file) to Change Defaults

  • I'd add a 'make sure you take a copy of the DTSX file before editing' warning to this. Do it wrong and it will no longer open in SSDT. Of course, if your packages are source-controlled, this is taken care of.

    For those who are interested in the structure of SSIS files and want to dig deeper, I'd recommend looking at the XML in a dedicated XML viewer/editor. Here is an example – makes it easier to see what is going on and navigate the entire thing.

    Changing the maximum size for many columns is tedious in SSDT, though I would warn against simply maxing the default in all cases. Doing so is much the same as creating a VARCHAR(500) column to store data which should not exceed 25 characters in length – some implicit data validation is lost by doing so. There may also be a performance penalty (I'm not sure about this). I tend to define SSIS maximum sizes to be the same as the columns they are being imported to.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • This reply has been reported for inappropriate content.

    This Post help us as a new users Thankyou for knowing about this Hacking.

    Housekeeping Services in Mumba

    Corporate Housekeeping Services in Mumba

    Cleaning Services in Mumbai

    Residential Cleaning Services in Mumbai

    Commercial Cleaning Services in Mumbai

    Housekeeping Services in Mumbai
    Corporate Housekeeping Services in Mumbai

    Cleaning Services in Mumbai
    Residential Cleaning Services in Mumbai
    Commercial Cleaning Services in Mumbai

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply