=============
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) NOT NULL,
[FolderPath] [varchar](150) NOT NULL,
[CurrentUser] [varchar](50) NOT NULL,
[CurrentDate] [datetime] NOT NULL
) ON [PRIMARY]
===============
Variables:
Check Int32 0
FileId Int32 0
FileName String StataContribution_20130903.xlsx
FolderPath G:\New folder\

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

public void Main()
        {
            // TODO: Add your code here
            string FileName = string.Empty;
            //Str st = new Str();
            string mm = "0" + Convert.ToString(DateTime.Now.Month);
            mm = mm.Substring(mm.Length - 2);
            string dd = "0" + Convert.ToString(DateTime.Now.Day);
            dd = dd.Substring(dd.Length - 2);
            FileName = "StataContribution_" + mm + dd + Convert.ToString(DateTime.Now.Year) + ".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

if not exists ( select fileid from  FileDetails where FileName=?)
INSERT INTO [Test].[dbo].[FileDetails]
           ([FileName]
           ,[FolderPath]
           ,[CurrentUser]
           ,[CurrentDate])
     VALUES
           (?,?,?,?)

select fileid from FileDetails where FileName=?


ParameterMapping:
-------------------------
User::FileName Input varchar 0 -1
User::FileName Input varchar 1 -1
User::FolderPath Input varchar 2 -1
System::CreatorName Input varchar 3 -1
System::StartTime Input Date 4 -1
User::FileName Input varchar 5 -1


Result Set:
--------------
0 FieldID

======================
Execute SQL Task: (2)
--------------------------
REsult Set: Single Row

select count(*) FROM [Test].[dbo].[StateConrtibution]
where  [FileId]=?




ParameterMapping:
-------------------------
User::FileId Input Long 0 -1

Result Set:
--------------
0 User::Check

======================
Presedence Constraint:
-----------------------
Expression and Constraint
Success
@Check<=0

-Logical And


======================


DFT:
Excel Source:
Rt.Click on Connection Manager->Expressions-->ServerName as @[User::FolderPath] +@[User::FileName]-->ok
Derived Column ->
FieldID , add new column,,@[User::Field], int, Map..
===================