As long as clients data is in SQL Server 2000 database tables, it is easy to migrate data from SQL Server 2000 to SQL Server 2008 using SSIS. You might want to create database and database objects in SQL Server 2008 that has compatible data types and other functions. Once you take care of this, you should be able to transfer data from SQL Server 2000 to SQL Server 2008. I have done this many many times and it should be very easy once you create tables in SQL Server 2008. One thing to make a note is, if there are lot of stored procedures, views, triggers, etc, you need to change the data types and functions compatible to SQL Server 2008.
Hope this helps to get you started. Let me know if you need further assistance.
commented on Apr 4 2011 8:00AM