Crispy Pepper Corn - A Munching snack

Ingredients: 

American Sweet Corn (golden)- 1 pack

Finely chopped Onions - 1 cup 

Green chilies - 7 to 8 (Slit along the stem)

Curry leaves - 2 sticks

Pepper powder - 2 tbsp

All Purpose flour - 1 cup

Corn flour - 1 cup

Soy sauce

Salt 

Ginger - Garlic Paste (Fresh Preferable)

Oil (Olive or Canola , depends on your usage)

Method:

First Coat for Sweet Corn:

• Take a mixing bowl .
• Add 2 tsp of ginger garlic paste, salt according your taste, pepper powder as per your taste (usually 2 tsp is enough, you don't want it to be too peppery! ) and 2 tbsp of all purpose flour to it. 
• Add some water, and mix it thoroughly(Add only little amount of water, to get the right consistency, you don't want it to be too watery!) to get it to a dosa batter consistency.
• Now, add the sweet corn to the mixture to get some coating over it. 
• Keep it soaked in it for few minutes. 

Second Coat for Sweet Corn:

• Take another mixing bowl.
• Add 3/4 cup of All purpose flour to 1/4 cup Corn Flour into the bowl.
• Mix the flours thoroughly.
• Add the soaked corn to the mixture, and see that you get a right coat. 

Do this just before you transfer the corn for shallow fry. So that coating remains intact until it goes for frying. If you do this way before, the coating is absorbed by the wet corn, thus making it a bad corn for the recipe. 

Shallow Fry the Corn :

• Heat a skillet filled with oil for a shallow fry. 
• When the oil is ready , add the corn (after the Second Coat) to it.
• When you add the corn to the hot oil, there are high chances that the corn splits and pops up onto your face, make sure that you protect yourself from the pops using a lid to cover the skillet partially. 
• Shallow fry the corn till they turn golden brown.
• Transfer them to a blotting paper to remove the excess oil.

Gravy:

• Heat the pan wit a little amount of oil.
• When the oil is sufficiently heated, add ginger garlic paste to it. 
• After the paste turns golden color, add the chopped onions, green chilies, curry leaves to it. 
• Keep mixing the contents until they all are thoroughly fried 
• Add a little amount of soy sauce, salt to it and let it fry again.
• Now add the shallow fried corn to it. 
• Let it be on stove for a while by mixing them. 

Switch of the stove! The crispy pepper corn is now ready to serve! This recipe is a nice munching snack for vegans!

Double Ka Meetha - Hyderabadi delicacy

Ingredients:

Bread (White Preferably, with edges chopped off) - 10 Pieces 

Milk - Half a litre

Chopped Almonds  

Chopped Pistachio 

Raisins 

Cashew Nuts 

Sugar - 1 cup

Water - 1 cup

Ghee - For frying the bread slices and nuts

Cardamom Powder - 2 to 3 tsp

Procedure:

Sugar Syrup 

• Add 1 cup of sugar to 1 cup of water in a pan and let it boil.
• Stir the mixture continuously.
• Add some cardamom powder to it and let it boil for some more time. 
• Switch off the stove as and when you see the bubbles over the boiling mixture. (The bubbles indicate that the syrup is ready to use) Let it cool down. 

Bread Pieces:

• Chop of the edges of the bread. 
• Cut the bread pieces across the diagonal or cut into four pieces. Defrost the bread pieces in microwave for 40 seconds, to remove any moisture from them, you can also put them under sun for the same. This will eliminate the absorption of excess ghee in the next step. 

• Heat the ghee in a pan and add the bread pieces to deep fry them. 
• Keep turning them occasionally until they are golden brown.
• Take the fried bread pieces onto a blotting paper , to remove the excess oil/ghee and let them cool down

Milk : 

• Take a pan, and pour half a liter milk in it.
• Let the milk boil till it reduces to half the amount.
• When the milk reduces to half the amount taken, switch of the stove and let it cool. 

Dry Fruits:

• Heat little amount of ghee into a small pan to fry the dry fruits taken. 
• When the ghee is ready , add chopped almonds & pistachios to it. 
• When the almonds and pistachios have fried half a way, add cashew nuts to it. 
• When the cashew nuts have turned a little brown, add raisins to it  . 
• Switch of the stove as and when the raisins blow up.

This is to avoid over burning of raisins and cashews.

Final Step: 

• Take an aluminium tray, grease it with oil or ghee to avoid sticking to the surface.
• Arrange the fried bread slices in the tray. 
• Pour the reduced milk and sugar syrup evenly over the arranged bread slices. 
• Sprinkle the dry fruits evenly. 
• Preheat the oven to 175 C
• Cover the aluminium tray with the foil.
• Place the try in the oven and bake it for 30 - 40 minutes  depending upon the milk/syrup added.  

After 30 minutes, remove the tray from the oven and let it cool. 

Slurp! Slurp! Yummy double ka meetha is ready to serve. 

SSIS - How to check if a File exists

Scenario:

We have a scenario, in which we have to check if a file exists in a folder. 

If the file exists , delete it and if the file does not exists, create a new one and append some data to it. 

Solution:

We can achieve this, using a simple script in "Script Task" in the Control Flow. 

Lets say, 

File name: Commands.bat 

File Path: I:\Commands.bat

Moving on to how to achieve this.

Step 1: 

Create the following variables at package level.

v_fileName = "Commands.bat" (Give the name of the file that you are checking for)

v_filePath = "I:\" (Give the folder where the file has to be located at)

Step 2: 

Drag and Drop the Script task from the tool box to the work space(control flow) and click on the bubble for ReadOnlyVariables.

Step 3: 

select the input variables for the Script task as shown below. 

Click on OK and then click on Edit Script

Step 4: 

Copy the code which is shown below

 Step 5: 

Execute the task to see the file created. 

Before Executing task

After Executing ScriptTask

SSIS - Executing a set of Command Line Arguments

Scenario: 

We had a requirement, in which a set of command line arguments had to be executed from an executable file (like cmd.exe, curl.exe etc. ) as part of an SSIS package. 

Solution: 

We can achieve this using a batch file and Execute Process Task. Lets see how we could do this in a simple way. 

Step 1: 

Open Business Intelligence Development Studio(BIDS).

Create a sample project by clicking on File - > New - > Project . Select Integration Services Project . Enter a name for the project. 

Create New Project

Step 2: 

Drag and Drop the Execute Process Task from the tool box to the work space. 

Drag and Drop Execute Process Task

Step 3:

Create a Batch file (.bat ) that contains the set of command line arguments that you want to execute. 

Create a new text file , enter all the commands, save the file name as Commands.bat

Set of Arguments

NOTE:
1) The first command has to be the Change the directory to the executable file you are using (Here, curl.exe, in your case it could be cmd.exe or any other executable file)


2) There needs to be line spacing between your arguments. If there is no line spacing, the batch file does not get executed as expected. 

Step 4: 

Configure the Execute Process Task in BIDS. 

1) Under "General" Tab, enter the name

2) Under "Process" Tab, for Executable , browse to the executable file i.e. batch file that has the arguments by clicking on the bubble. 

3) click on OK

Step 5: 

Execute the package to see the arguments in the batch file to get executed . 

Navigate to the curl.exe path to see the sample.csv file created with the data. 

P.S: 

The arguments in line 2 and line 3 are there to import data from a web page and append to sample.csv file.