1. You are actually asking a BusinessObjects question, not a database question. 2. You will probably get better results if you ask on the appropriate site. Try http://www.forumtopics.com/busobj/about.php[^] Tim

Hi Abhijit/CodeManiac, Expert exchange displays the answers at the bottom when your referrer is Google. Try searching for the question title "Linking, Connecting MS SQL 2000 to AS400 Database" using Google, go to the first result, and scroll down to the bottom of page to view the replies. Hope that helps. Regards, Syed Mehroz Alam My Blog | My Articles Computers are incredibly fast, accurate, and stupid; humans are incredibly slow, inaccurate and brilliant; together they are powerful beyond imagination. - Albert Einstein

Use split transformation to split data in two types: one where claim number is 123456789 and everything else. Then use derived column transformation to make necessary changes. Giorgi Dalakishvili #region signature My Articles Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^] My blog #endregion

If you've created the package using Business Intelligence Studio, hit F4 on the package and you'll find version number, major and minor.

Shouldn't be a problem then. I always try to have the database engine do most of the work.