SELECT
  item_name
,  category = (CASE
       WHEN item_name IN ('charger', 'cable') THEN
         'electricity'
       WHEN item_name IN ('pen', 'pencil') THEN
         'accessories'
       ELSE
         'other'
     ...

You have missed a step, I think.
Create a new string variable, to hold the file name.
Configure the FEL to map the 'current' file name to the variable you have created.
Use...

Thom, I have not read your code in detail, but doesn't running a package execution in SYNCHRONOUS mode obviate the need for this polling?

Is G: a local or network drive? 
Does the SQL Agent user have rights to the folder?

Jeff Moden did some articles on this. Start here and see how you get on.

Try something like this

DATEADD( "d", -1 * DATEPART( "d", GETDATE() )+1 , GETDATE() )

Replace GETDATE() with your variable name.

SELECT DATEADD(dd, DATEDIFF(dd, 0, GETDATE()) - 1, 0);

Change -1 to -2 for day before yesterday.

For file operations, I would normally expect to see a File System Task or a Script Task being used. Why are you calling an executable to do this?

Please read Chris' post again, particularly this:

He's giving...