Month: June 2016

SSIS – Error 0xC020200E – Cannot open the datafile “PathToFile”

This error presented itself when attempting to run an SSIS package that needed to write to a file share across the network to another server. The package worked when executed using my local account from Visual Studio but not when invoked from a stored procedure or via SQL Server Agent. A fully qualified UNC path was being used. The Agent job Owner…

SSRS 2008 – index was outside the bounds of the array / Data source does not exist

Experienced this generic message from Bids / Visual Studio 2008 during a Reports migration project. No further information was provided. Most discussions online mention resolutions around report caching which wasn’t applicable in my case. I resorted to the classic trial and error method – hack away removing objects from the report until the error message changed! After removing everything from the report bar the main…