Hi Vikash, You need to use XPATH correctly. Check for the XPATH samples in the link I provided from W3School.com....

Hi akhil, Can you provide more details as to what you need and what are the input and output sources?...

Hi Kathy, Have a look at this: http://beyondrelational.com/blogs/sudeep/archive/2009/11/19/dynamic-file-connection-in-ssis.aspx...

substring(columnName,1,FINDSTRING(columnName,"@",1)-1) just check if this gives the right ouycome else remove the -1 from the end......

Could you please elaborate....

@clhundson47: Check the file name that you have in the table. Does the file name contain .txt?...

Thanks Vishal, Have a look at this blog of mine where I put the [details of Foreach loop in another example][1]. [1]: http://beyondrelational.com/blogs/sudeep/archive/2009/11/19/dynamic-file-connection-in-ssis.aspx...

Hi Vishal, Thanks. In SQL depends whats the scenario. If it is a table you could use ISNULL() or coalesce function to handle nulls......

Using SSIS this is the best option that you have. Ma be you could delete the CSV file after the load or in case of error in the package as a clean up. This will ensure that no data is stored. There are other tools you could use have look at the link...

Hi Jinesh, how much data do you intend to transfer? You can use a Data FlowTask with OLEBD source to get the data from DB2(provided you have the connection) and oledb destination to load the data to Oracle. You might want to check the performance of ...