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.).
James Connor
Valued Member
Points: 57
More actions
June 10, 2008 at 2:15 pm
#826971
If using SSIS and the package will be running on the sql server itself then you can use SQL Server destination but if the sql server is on a remote server, you'll have to use an Ole DB destination.