Dear All Thank you for your inputs. Its really helpful to me.
I have set 8 CPU and 32 GB RAM to my machine. I have done transaction insert and...

Below code is working fine now. Thanks to all for suggest solutions.

DECLARE @count1 NVARCHAR(20)

DECLARE @qry4 NVARCHAR(1000)

DECLARE @qry5 NVARCHAR(1000)

DECLARE @ParmDefinition NVARCHAR(500)

SET @qry4 = 'SELECT @countOUT = COUNT(*) FROM '+@file_name1+'..WebProxyLog'

SET @ParmDefinition =...

Thank you. The problem has been resolve.

This is helpful link.