Posts Tagged ‘bids’

SSIS: Failed to load XML from package file

I recently came across this error in one of our SSIS packages. Description: Failed to load XML from package file “C:\Path\To\Package.dtsx” due to error 0xC00CE508 “An invalid character was found in text content. Line 426, Column 104”. This happens when loading a package and the file cannot be opened or loaded correctly into an XML […]

My Favourite SQL Tools

BIDSHelper Enhances and extends the functionality of BIDS. I’ve mainly used this with SSIS but there are many tools for SSAS and SSRS included in the package. Two of my favourites include the variable editor (useful when you add them in the wrong scope) and the deployment wizard. These two things alone have probably saved […]