=============
CREATE TABLE [dbo].[StateConrtibution](
[LoanAmt] [int] NULL,
[FileId] [int] NULL
) ON [PRIMARY]
==========
CREATE TABLE [dbo].[FileDetails](
[FileID] [int] IDENTITY(1,1) NOT NULL,
[FileName] [varchar](50) NULL
) ON [PRIMARY]

GO
===============
Variables:
FileId Int32 0
FileName String G:\New folder\StataContribution_20130903.xlsx

======================
Sript Task:
Read write variables: User::FileName

public void Main()
        {
            // TODO: Add your code here
            string FileName = string.Empty;
           // "G:\New folder\StataContribution_20130903.xlsx"
            FileName = "G:\\New folder\\StataContribution_"+Convert.ToString(DateTime.Now.Year)+"0"+Convert.ToString(DateTime.Now.Month)+"0"+Convert.ToString(DateTime.Now.Day)+".xlsx";
            Dts.Variables["FileName"].Value = FileName;
            MessageBox.Show(Dts.Variables["FileName"].Value.ToString());
            Dts.TaskResult = (int)ScriptResults.Success;

        }
====================
Execute SQL Task:
--------------------------
REsult Set: Single Row
SQL Stmt: insert into FileDetails values(?)

select MAX(fileid)fileid from FileDetails

ParameterMapping:
-------------------------
User::FileName Input varchar 0 -1
Result Set:
--------------
0 FieldID

======================
DFT:
Excel Source:
Rt.Click on Connection Manager->Expressions-->ServerName as @[User::FileName]-->ok
Derived Column ->
FieldID , add new column,,@[User::Field], int, Map..
===================
if not exists ( select COUNT (1) from  FileDetails where FileName='Naresh.xls')
insert into FileDetails values('Naresh.xls')

select MAX(fileid)fileid from FileDetails
select * from FileDetails