Home Forums Data Warehousing Integration Services Exception has been thrown by the target of an invocation. SSIS Package. Integration Service Catalog RE: Exception has been thrown by the target of an invocation. SSIS Package. Integration Service Catalog

  • Sql Server Version : 2014

    It is a problem in accessing Network Share Folder Paths from SQL Server.

    Example when others try to upload the blob file , it is throwing an error.

    INSERT INTO [dbo].[TEST](LOG_DATA,T_DATA_PROCESS_STATUS,T_USED_ID,T_STAT_ID,T_INSTANCE_ID) SELECT BULKCOLUMN, NULL,

    '1',NULL,1 FROM OPENROWSET( BULK '\\NetworkServerName\temp\client1092\output\Blobfile.txt', Single_Blob) as TBL

    Cannot bulk load because the file "\\NetworkServerName\temp\client1092\output\Blobfile.txt" could not be opened. Operating system error code 5(Access is denied.).

    SSIS package when I try to read directory Information, it is throwing an "Exception has been thrown by the target of an invocation."

    This is only problem with others try to upload and read directory information , I checked the network directory settings for me and others same. but it is working fine for me, I can able to upload and read directory information, but others not.

    I feel is that SQL Server permission issue , I have added separate account "domain\userid" with permission of BulkAdmin, public.. Even others added with different groups and permission also same.