Hello, I have my filename in a variable in form of a sting. I need to extract a part of this string and insert it into the database. Is there some SSIS task which I can use for this purpose? Thanks, Charu

Yes there is such a task, it is called Derived Column Transformation. You will need to use an add column option with a SSIS expression involving SUBSTRING function. Example: http://www.bimonkey.com/tag/derived-column/Arthur My Blog

You don't need the Data Flow Task and Derived Component for this (like what Arthur suggested). You can extract the information from the variable and insert it using the standard Execute SQL Task.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/