Home Forums SQL Server 2005 SQL Server 2005 Integration Services "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT' could not be opened. Operating system error code 5(Access is denied.). RE: "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT' could not be opened. Operating system error code 5(Access is denied.).

  • September 16, 2010 at 1:33 pm

    #1222535

    tgarber (9/16/2010)

    Has anyone resolved this problem OTHER than switching away from the SQL Server Destination? I've seen lots of posts about this and the "solution" seems to be to use OLE DB Destination which I understand is slower.

    The OLE DB Destination isn't that slow if you use the fast load option. Performance wise, it comes close to the SQL Server Destination.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP