This is simple in SSIS, and had you posted the question in the Integration Services forum, you would have had an answer by now.
Use something like (untested)
[code...

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.