Post reply

"Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT' could not be opened. Operating system error code 5(Access is denied.).

  • January 18, 2013 at 2:22 pm

    #1578886

    Actually, I've never had to change from SQL Server Connection to OLE DB. I've seen this issue when I've moved SSIS packages from one server to another and forgot to change the individual connections within the package to point to the new server. I modified the connections and presto! Problem solved.

  • March 28, 2013 at 6:17 am

    #1601584

    sconte 67456 (1/18/2013)

    Actually, I've never had to change from SQL Server Connection to OLE DB. I've seen this issue when I've moved SSIS packages from one server to another and forgot to change the individual connections within the package to point to the new server. I modified the connections and presto! Problem solved.

    Can confirm this is the case when moving packages from one server to another.

  • June 27, 2016 at 12:53 am

    #1886963

    If anyone else has this issue, I found that changing the SQL Destination from SQL Authentication to Windows Authentication worked for me.

Viewing 3 posts - 16 through 17 (of 17 total)

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