DECLARE @test-2 TABLE
(
EmpName varchar(50),
Deduction MONEY,
YearMonth int
)
DECLARE @CurrentYearMonth INT,
@PreviousYearMonth INT

SELECT @CurrentYearMonth = 201805, @PreviousYearMonth = 201804

INSERT @test-2 Values('John', 259.05, 201803)
INSERT @test-2 Values('John', 325.50, 201804)
INSERT...

You can either run the package through the Integration Service Catalog or download the package on the file system and execute it from there. Have you tried testing this package...

From the error you are getting it sounds like you have the text '@Counter' in your dynamic query text. But the code you have pasted in doesn't have a problem....

select *
from @table
pivot
(
min(comment)
FOR comment_id IN ([1],[2],[3],[4],[5])
) AS PivotTable;

A few years ago someone was moving a database (without doing a backup first) and when they reconnected somehow the log file was elsewhere. This corrupted the mdf file.
To...