Archive for September 2013

Who’s in those AD Windows Groups setup on SQL Server?

Warning: count(): Parameter must be an array or an object that implements Countable in /home/fbsqlcom/public_html/ on line 31

I wanted to be able to check which windows users had been placed in the Windows AD Groups we use to control access to SQL Server. Here’s what I came up with to make checking this easy; ?View Code POWERSHELLImport-Module SQLPS -DisableNameChecking -ErrorAction Ignore; Import-Module ActiveDirectory -DisableNameChecking -ErrorAction Ignore;   $sql_server = "sql_instance"; $srv = […]

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 […]