Hi i create a package in SSIS.. my source is excel file in that excel file i m having column called to_Day date,and my source is SQL server in that i am having table called load_logic now i want to take a load_date column from load_lgic table and compare this to to_Day date column excel file how to compare excel data and sql server data while inserting rows so if that excel data to_day date is greater that load_logic_date then i want to insert these rows in table A...How to do that in SSIS..

Are you matching rows from your Excel source and your SQL Server source (load_logic) on some key first? And you want to compare the to_Day column from Excel to the SQL table value load_date column? Or does SQL Server source table load_logic have one load_date value and you only want to get the Excel rows where to_Day is greater than that single load_date value?Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008 Blog: http://www.bidn.com/blogs/RussLoski/ Twitter: @sqlmovers

Are you matching rows from your Excel source and your SQL Server source (load_logic) on some key first? And you want to compare the to_Day column from Excel to the SQL table value load_date column? Or does SQL Server source table load_logic have one load_date value and you only want to get the Excel rows where to_Day is greater than that single load_date value?Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008 Blog: http://www.bidn.com/blogs/RussLoski/ Twitter: @sqlmovers