hi, i need to get latest value which will bein lasr row of the table from only 1 files into variable using ssis. how cani achieve that

Are you reading the values from a sql table? assuming that is the case then you can use Execute SQL task. You configure the query as Resulset = single row your query will be something like Select top 1 YourValue From YourTable order by ENtreOrder desc Then in Parameter mapping, you map YourValue to your variable with direction output

Your question is bit confusing. Are you reading last row from files or SQL Table?Vikash Kumar Singh || www.singhvikash.in

what should i write in parameter name and parameter size

Parameter Name should be a numeric value starting from 0 to the number of parameters you have. So if you have 3 parameters to set up. You should have a value of of 0 -- 2 for the parameters. Parameter size should be left as -1 which means it takes the default value from your definition (i.e. the data type)

Parameter Name should be a numeric value starting from 0 to the number of parameters you have. So if you have 3 parameters to set up. You should have a value of of 0 -- 2 for the parameters. Parameter size should be left as -1 which means it takes the default value from your definition (i.e. the data type)