hi, i have to load name of file in filename column of table eg if file is abc.brd then abc must goes into table as filename how can i do this through SSIS

You would use an expression that uses findstring to get the position of the . and then substring to extract the piece of the data you are interested in. Special today - Fishing poles, all out of fishChuck

but how can i get file name in variable, then i can use the expression

If the filename is in a column you would not need a variable. You would use a derived column block in the dataflowChuck

Lets start with the basics - where are you getting the filename from?Chuck

Hi baba k, According to your description, the filename is stored as a column of a table, right? Please correct me if my understanding is wrong. In that case, you can use Execute SQL Task to execute a query to retrieve the filename, and then save the result to a variable. For more information about it, please refer to the following links: http://msdn.microsoft.com/en-us/library/ms141689.aspx http://www.sqlis.com/sqlis/post/The-Execute-SQL-Task.aspx Thanks, Eileen