hi i create a package in SSIS.. I want to get a value for variable in between source and destination..like ex: i am having excel source and sql server source i merge join this 2... after that merge join i will get one value so now u want to take this value and pass to variable..how to do that in SSIS

reading and writing variables in a dataflow can be done with a Script Component: http://microsoft-ssis.blogspot.com/2011/01/how-to-use-variables-in-script.htmlPlease mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter