Also when I tried the option which you had suggested regarding the for loop, it gave me the following error.

Error: 2008-09-26 16:53:51.32

Code: 0xC0202009

Source: d_ccrs_obligor_stg_ld...

For the null values, I cannot replicate it right now, as I have changed my package a lot, but it was giving something like:-

The external metadata column collection is out...

Hey thanks a ton!

Can you please give some pointers on the null value problem? Also we have few more issues:

1. How to initialize global variables in SSIS with the values...

I am sorry I did not understand..

What exactly to put in the connection string and the ExcelFilePath properties ?

Given my variables in the above reply, can you please let me...

Thanks a lot. I have already used a global variable:- gv_FileName, it appears in the foreachloop variable mappings as User::gv_FileName.

Now in the expressions of the excel connection manager, I have...

Hi Mukti, Thanks a lot for your help. this is my detailed issue.

The need is the upload 1 row of multiple xls files each to the database from a folder....